"Does Dreamhost offer any kind of refunds?"
There is a 91 day Money Back guarantee. So you should be able to geta full refund.
"For one, with my old host, when I uploaded to my site, everything was visible immediately. I only switched hosts, because Dreamhost offered a good deal on bandwidth/space."
Anything upload to you site IS visible immediatly. if it isn't you are doing something wrong (or there is something wrong with your site.
"I don't like how I can't restore my blog database without having to know some hi-tech commands or whatever. "
It can all be done from the phpMyAdmin screen of your old host (to save your data) and then the same screen on dreamhost. Point and click. no Hi-tech commands.
MP3Mystic Your personal Streaming MP3 Server