Another modest site:
Uses the modules: CCK, SMTP, heavily modified Alex Theme, Five Star, AutoPath, BUEditor, Google Analytics, Token, IMCE (why isn't this a built-in?).
It took about 5 days to setup (mostly learning how to configure and install modules and to use multi-site).
I also plan to use Drupal for http://www.lurkerfilms.com and http://www.silverkeymedia.com.
Once I discovered IMCE life was much better.
Multi-site is a bit wacky considering you can't really use site relative urls (relative to the site directory under the sites directory) because once you start adding links you are stuck unless you use update the sql file doing search/replace ... this only is a concern if you use say mysite.local for testing before switching over to mysite.com.
Still not sure how to model many to many relationships (cck vs. vocabulary terms)... for example a guest or a film could appear at multiple festivals so when creating a guest content type I need to either tag the guest with tags like "2008, 2005" and then perform searches for the index page on all content types of type "guest" that also contains vocabulary term "2008" for example. Or I could create a CCK field that allows selection or a list of years the guess participated. Or I could create a new guest node instance every time the guest appears at the festival and not try to have a single node representing the guest.
I plan to add a bunch of CCK fields in the next couple of days to film and write a custom template for it as I did for http://zompire.com
Drupal could be really great for film festivals and I may work on a profile for specifically that. If this was more turnkey it will catch on like fire.
I got the religion. Still have a lot of work to do.
