With Vista SP 1, the Compatability mode should be set to WinXPSP2 mode and then the game will run flawlessly. I currently run HW2 on my Vista machine., and for those looking to the future already... Windows 7 will run the game as well.
If you need a beta tester, let me know!