Following on from your thread in the Helproom (for anyone who hasn't seen it click here ) I have to say I agree that the Open source stuff does give the better deals.
Re my PS in the other thread - you mention ISP, which was what was confusing me. Since you have now clarified stand alone web hosting, it makes it a little easier. Most people tend to go for the Open Source (PHP with a mySQL database) approach. This could be due to a few reasons like price, speed, ease of support etc.
I personally use a PHP / mySQL hoster, but these also support Frontpage extensions if you want to use these instead.
Like exerything else in PC land, it's all a case of personal preference. Generally speaking however, you can do everything in a PHP / mySQL site that you can with an ASP / JSP with an Access or SQL database one. And I think the general opinion is that if you want things like forums etc, then go for one with a mySQL backend. I think it's a little faster, and takes less server resources.
Hope this helps a little. If you could give an idea of webspace / bandwidth needed, maybe someone can come up with a few suggestions for you - even comaprisons between a Windows (ASP) hoster and a Linux (PHP) hoster.