I can give you a couple of hints design wise.
1: Dodgy EffectsI'm talking mouse-trails, blinking text, Javascript tickers... all very dodgy things indeed. Personally, I avoid Javascript and Flash, simply because it's too easy to add in very tacky effects that has no contribution to the site.
2: Colour SchemeImagine you're living room in those colours; if you can live in it, your site should be okay. Especially avoid red/green combinations, as they are both light colours and make it hard to read, plus many people are red/green colour blind.
3: Hit countersDepending on how popular your site is, it either lands up very embarrassing ("You've had: 4 visitors since 1993!") or very boastful. There is no middle ground.
4: Generic ClipartA baby smiling. Businessmen shaking hands. Rubbish web design. And while you're at it, dump the background images too - black/white or a plain colour works so much better.
5: Splash pagesYou can make a site with a good looking homepage, so there is just no need. Javascript/Flash checks can be done using a re-direct and tailoring specific splash screens for certain search engines is just lame, really.
6: KISSNothing to do with a certain glam-rock band, and I'm certainly not going to give you one. It stands for 'Keep It Simple, Stupid'. Remember that and you'll do well, grasshopper.
Remember, Webmonkey has some good design hints too.
http://www.webmonkey.comPersonally, I'd avoid templates as much as possible, but if you really want to, try
www.elated.com. They've also got some decent hints and tips.