It used to be that you had to be a computer programmer to make a decent website, but now anyone with a little time and effort can have their own amazon.com. Grab a copy of drupal, load it up add a few modules and you have an instant fully functional heavy duty website. The only issue is the design. Typically you have to use the pre made templates or go out and by a theme for your drupal site. There is a way around this though. Make your own themes.
A theme is basically the look and feel of your site. In drupal you can easily make your own them with just a little html knowledge and maybe an understanding of how php works. I don't mean you have to understand either just how to recognize both.
Themes for drupal are pretty much a set of a few different html files that serve as templates. You put placeholders in php for your dynamic content. Knowing this it is easy to take a look at an existing theme and reverse engineer it. Give it a shot. The worst that could happen is you don't like your design and end up using a pre made template.