I have been using Windows with Boot Camp almost exclusivelly on my MBP ever since I got it [middle of June]. So it is the latest MBP with the Santa Rosa chipset. Started off with BootCamp 1.3 as it just came out at that time with updates for the latest MBP's, and recently moved on to BootCamp 1.4.
I have never had any issues with BootCamp other than the standard issues you might have on any typical Windows computer [possibility of spyware/trojans etc]. All the drivers work perfectly [including iSight], the keyboard lighting sensors etc.
My main reason for acuiring the Mac was that I needed to also have a development machine with OSX [in addition to Windows]. The looks were quite a bonus.
With that said, should you follow all of the instructions with BootCamp to the letter, I don't see you having any issues with it. Most of the reported problems were due to user errors. Two observations, though:
1. Make sure you properly calculate how much space you need on the Windows partition. Once you install Windows, the only way to resize the partition is to reinstall Windows.
2. The battery capacity is a bit lower on the Windows side. Some people have said that this is due to OSX's better power management.
And have fun. The MBP is a great machine. And for the money at this point, I don't think you can get anything better.