The hype has subsided in the enthusiat crowd, mainly because the SiS 735 and VIA KT266A have come out, matching or nearly matching the NForce's performance. When it was first announced it was destined to be the best performer, now it's not.
That said, it is still a very good chipset, especially if one needs a barebones starter system. It is simply the best integrated chipset on the planet for any platform. For it's ease of setup(except for Win9x/ME) and it's adequacy as a starter gaming system, it has no competition.
Personally, I didn't buy into the hype much. This is mainly because, when I think of Nvidia, the first thing that pops in my mind is drivers. Not good drivers mind you, but a plethora of drivers where some work, some are glitchy, but eventually there will be some drivers that make everyone happy. I've used an NForce with WinXP though and all I have to say is that it is a great chipset with a great entry level onboard graphics capability. RTCW ran at least as good on the NForce as it does on my Voodoo5 5500 and that is pretty impressive considering that the MSI 420D mobo it was on is only a little more costly than what I paid for the Voodoo5!
For those wanting to do a complete upgrade, but want to wait for future generations of video or sound, the NForce is easily an excellent option.