Buy 64 bit version and pack it with RAM. I did that with mine and running The Wither 2 with almost max on HD res;> Of course it needs neat CPU and GPU but not latest.
Weird things - where are the firewall settings (wf.msc). Where are network connections (network center and 'change the network card settings' - reverse translation). You need to do a little research if you want to use it with current media types (X264/DTS in mkv with srt) but it's doable - force Direct Show and use MPC with ffdshow.
My Win7 doesn't like my 300 GB IDE HD and few times a day it says it's gonna crash soon.
Cool things - show pulpit at click in the right bottom corner, slideshow as wallpaper (but I can't change background colour - it reverts to gray), libraries of pictures, video, music, Live package which is free and contains mail program, Media center (listen to music and watch random pictures, and movie maker. I recommend instant download. Vista shake and Windows+Tab application changer. Defraggler, Ad-Aware and NOD32 are working fine with it.
Crappy things - New Quick launch bar is now mixed with taskbar - and I can't use it effectively (in XP I've had bout 20 different shortcuts there with autohiding taskbar). We still live in 32 bit world so some old application wouldn't work and there's no 'stable' Flash player for 64 bit IE (but I encountered the problem once or twice only.
Heavy modded Oblivion (maxed, HD resolution) is running very similar on this two machines
Q9650, GTX8800, 3GB RAM, XP Pro 32
Q9650, GTX560Ti, 8GB RAM, Win 7 Pro 64
I guess the bottleneck is decompression of high res textures packages. Certainly not because horse armor:)