I'll have to see which of the newer NFS series I have installed, but the only one I remember having trouble with was The Run because of the stupid "real time events" where you have to suddenly press one button or another.
A lot of new PC games do only support xinput (xbox360/xbox1).
Check out x360ce. It creates a virtual xbox360 controller using your directinput controller.
There are a lot of preset game-specific profiles for the G27.
xinput doesn't have direction feedback, so I'm guessing all you get is rumble.
I've only ever used it on simpler games that only had rumble to begin with.