This is not a difficult concept. Words crawling across the screen are cute. So are spinning, twirling, rotating logos. A musical stinger or a little drum roll is cute.
Videos are cute.
If you've seen one rotating logo, you've seen 'em all. Concentrate on the content. Don't forego cuteness, but don't let being cute be the entire reason your Web site is there. Web designers have a technical name for sites that depend on all the gee-whiz features to the detriment of the content. If one of the reasons your Web site exists is to sell sound, by all means use sound on the site.