Before being a customer i heard both good and bad things about Dreamhost.
So i decided to check it my self.

First of all i must say that they have a fairly good customer support service.But i must say that my site experienced down time in few occasions with in the first week.They did managed to fix it reasonably quickly as i complained but that created a bad image in my mind about Dreamhost.

Well talking about the customer expertise needed, i found that they do not provide much assistance with the mysql options.Here is an email that i got regarding an inquiry about an PHP installation,
"Hello Thelahera,

You are using the default. If you'd set up your own, you'd know. As far
as I know, our default PHP installation does meet those requirements, but
if you do run into problems, bear in mind, we can't offer assistance when
it comes to custom configurations, but you can always turn to
http://discussion.dreamhost.com for help from your fellow users (who
maintain much of the custom configuration and 3rd party software articles
on the wiki anyway).

Please let me know if you have any other questions!"
but i must say i'm pretty satisfied with the support service.

I would say dream host is suitable for any kind of customer from beginner to large site hoster.It will be good if they can improve the features in the c panel though.

Finally i say i can recommend Dreamhost to my friends..but must not forget the fact that they have to improve in some areas to be a better hosting provider.