Hey man. I'm a picky gamer too. Lol I hate FPS games but the game that I play the most is Counter Strike Source (CSS). I'd definitely recommend it.
Have you tried downloading Steam? They have alot of demos on there so you can try a game before you buy it.
If you do end up buying CSS there is a free mod for it on steam called Insurgency which is like a whole game for free! It's a game that relies heavily on strategy and tactics. It's set in Iraq. Welcome to Steam
Other games that I play on windows 7 are
-Planscape Torment (RPG)
-The Longest Journey (Point and Click adventure)
-Max Payne 2 (Third Person Shooter)
-Sacred (Action RPG i.e. like Diablo)
As for Racing games, besides Gran Turismo, I really don't like them. I can't stand the Need for Speed series. Tried one of them last year and they still suck.