Thanks for all your help guys, I looked at all those and tried searching with different key words and I found..
http://www.appliedi.net/iis7-hosting/iis7-features.html
Just got off their Live Chat, for anyone else who's looking for a host that fits the loose description I gave in my OP, these guys seems to rule! Last windows host I had, you had to use their web interface for everything! Uploading the site, the database management, etc!
These guys allow use of SQL Management Studio, using stuff like Subsonic, have 3.5 sp1 IIS7 and MS SQL 2008!
Think I'll look for reviews of their service and if all is good I'll sign up.
Thanks again.