As this is my first ever post/comment I'd like to thank CD Projekt Red for this amazing game. I adore it.
There are a few FWD and 4WD cars in the game -
https://rankedboost.com/cyberpunk-2077/vehicles/
In real life RWD is the most fun IMO. The driving in the game is fun but could use some tweaks to make it a little more predictable whilst retaining realism.
I'm posting to contribute another suggestion for cars - I'd love the automatic gearboxes to be realistically coded so that a gentle press of the throttle (on console controller, or analogue pad on PC) means that the car shifts up a gear from a lower rev range (i.e. changes gear earlier). Outside of racing games, the only game series I know of that has achieved this is Mafia (by Hanger 13). It contributes a lot to realism, enabling different driving behaviours which reflect the current activity. Cruising around the city? Low revs - gentle and relaxed. On an urgent job? High revs - exciting and loud. It's also a lot of fun when cruising, to suddenly hammer the throttle and listen to/feel the car drop down a gear to accelerate hard.
I reckon the maths of coding this would be interesting and not too difficult. The logic has been around in the real world since the 1950s. A real life car takes input from the throttle position, speed, and rate of acceleration/deceleration, to calculate when to change up/down. Modern (1990 onwards) cars also record the last 10 minutes' of driving behaviour to detect how "heavy footed" the driver is. Heavy footed = gearbox will hold on to gears for longer, meaning that the car is ready with the right gear in anticipation of the driver pressing harder.
Cheers