I've heard people mention Oblivion get very close to 2GB when the super high res textures are used, and the grass details are set very high etc.
Now if Vista needs a little more memory than XP I can see how it could push it past 2GB, but that is only one game.
Perhaps photo and vid editing benefit more?