Ive been searching on the drupal site and it seems that most of the themes there are plain and ugly. Is there another place I can get drupal themes or are drupal themes just ugly
Though I am a Drupal user and contributor for more than 2 years, I have to agree with the starting post. There are only a few good looking themes available for Drupal. That's why I am starting developing and porting themes onto it, to make it a little sweeter than now. One theme is ready now, with PSD downloads at templates.m42.hu Expect more to come (sorry still no permission to post links here)
there are a few decent drupal theme sites. One i know of is http://drupalshark.com but they are few and far between. Here's my review of Drupal 6.2: http://cmstester.net/drupal-6-2-review/
Drupal is only limited by your imagination. Any website you can make can be turned into a drupal theme with limited effort. themegarden is a good place to start, or as people have already said get someone to create a new theme for you.