The 2GB limit is inherent to Windows, not a Bootcamp issue. There is a tweak to increase it to 3GB. I’ve been using Windows x64 which doesn’t have a per app RAM limitation. Not officially supported by Bootcamp, but have read about users who have intalled it on their Mac, and “screams” or so they claim.
I agree with your comment about AppleCare. This is where the PC is a better option, the spare parts are readily available and easy to replace, and cheaper, but guess that’s the same argument GM owners have when jealously eyeing a Mercedes…