It doesn't matter if you do all the error checking in the world, or if you have the most beautiful graphics, if your site or application design isn't usable, it's not going to do well. Get input and advice on usability and user interface issues here.
I guess that most people like more bright designs (not like the yellow one though... too bright!). Personally, I like simple designs with a bright color scheme.