According to Steam the most popular resolution on PC by far is 1920x1080 and 1366x768. In fact the majority of Steam users seem to have pretty weak PCs. The Intel + Nvidia combo seems to be the most popular.
http://store.steampowered.com/hwsurvey
I had a Sapphire 290 Vapour X for about a week and sent it back for a MSI 970 GTX GE as it was more powerful and cheaper. I was pretty lucky as I got nearly all my money back and got to keep the 3 free games (Gold offer) AMD were giving away with their GPUs. It's my first Nvidia card in ages and I was impressed by how much smaller the 2 fan 970 was compared to the behemoth that was the 3 fan 290.
I concur with those who say such cards are not overkill for 1080p gaming. Graphics are getting more complex due to the current gen consoles and brute forcing your way to ultra settings @ 1080/60 will be more problematic compared to the last few years of last gen console ports.
For those sitting on the fence I'd wait for 6-8GB VRAM cards if you have the patience and want to play at ultra settings.
