I recently launched a new site that's being hosted on HostMySite.com. It's been quite some time since I've had a site that wasn't hosted in house and have to admit that using HostMySite was painless.
Model-Glue works with their setup out of the box, and they were extremely helpful as we got things setup for the first time. You have to love 24*7 tech support that's actually 'with it'.
My only complaint is that I didn't have access to restore or backup my database, so I had to rely on DTS, although they can do these things for you if you request it. I imagine this is an issue with most shared hosts as SQL Server security surrounding restore and backups isn't easy to hand out to everyone.