I've got a G27, had it since March 2012. It's a great wheel, my only real complaints are that some of the buttons aren't quite tactile enough and the layout is a bit awkward (the ones on the wheel sometimes feel like you've pressed them but they don't respond correctly, it's hard to find a particular button on the shifter sometimes without feeling around for it first, that sort of thing), the pedals are loud which completely negates the point of having a relatively quiet helical gear feedback system, the wheel itself is quite quiet but gets louder when you're being, er, vigorous with it... But on the whole, it's a very good wheel if you can overlook those problems.
As for Project CARS, it's pretty great right now but needs some work, fortunately they're updating it weekly and work is progressing nicely, unlike some other pre-release games (like Next Car Game - sorry - Wreckfest), so I think it'll be a very compelling purchase when it releases. I'll admit I haven't played it for some time but even a few months ago it was insanely good fun just doing time attacks in the Group 5 Zakspeed Capri. Not the best sim ever but it's not meant to be, it's straddling the line between the higher-end console sims (GT and Forza) and the medium-high end PC sims like rFactor. It works perfectly with the G27, shifter and clutch included.
Other racing games/sims I've used my G27 with include (all on PC except GT5 and GT6, by the way):
- NFS Shift
- Shift 2
- Grid
- Dirt
- Dirt 2
- Dirt 3
- GT5
- GT6
- GTR 2
- GT Legends
- Race 07
- rFactor
- rFactor 2 (demo)
- Game Stock Car (demo)
- RaceRoom: Racing Experience
- Euro Truck Simulator 2
- WRC 3
- WRC 4
- Richard Burns Rally
- Grand Prix Legends
- Colin McRae Rally 2004
- Colin McRae Rally 2005
- Next Car Game aka Wreckfest
- Assetto Corsa
- Live For Speed
All of these work great (though quality does vary greatly!) with a wheel, well enough for me to recommend a wheel over a controller. That can't be said for all games, though; Test Drive Unlimited 2, The Crew (beta) and F1 2011 (and apparently subsequent releases) seem pseudo-simmy with their explicit wheel support - TDU2 and The Crew even support H-shifters and clutches - but they're crap with a wheel and definitely handle better with a controller.
Then you get into your genuine arcade* experiences like Burnout Paradise, FlatOut, Ridge Racer: Unbounded... Don't even bother! I even tried Driver: San Francisco with my wheel once, that was an exercise in absolute futility. GTA IV worked ok, though, as long as you have a controller on hand for when you get out of the car. I wonder what GTA V will be like?
*I hate that a lot of people - sim snobs, mainly, often rFactor or iRacing players - describe anything that isn't a proper 'sim' as being 'arcade' or 'simcade' as if it's a derogatory term. I often hear NFS: Shift being described as 'arcade' but it clearly isn't an arcade game, it's a casual racing game. Really minor #firstworldproblem rant but I figured I'd qualify my use of the phrase 'genuine arcade'.