I love dreamhost, and I think it’s awesome for personal sites. If you want to host a blog, some forums for a small group, etc., there’s no better value in my mind. But if you have a heavy database application and a lot of hits, I don’t think you’d love it as much as I do. I’ve found that there’s almost always a delay when I do database transactions. I’m not sure, though, if it’s just a bigger hit when connecting, or if it’s steady throughout the entire transaction.
DreamHost does have a 91 day guarantee, though. So you could certainly try it out, and if it doesn’t work out, get your money back and try something else.