Multiple people here are missing the point. I'm primarily focused on performance here, and I discussed that at length. You're all getting hung up on the "RT Overdrive doesn't radically alter the way the game looks." Yes, it absolutely changes the lighting, it's more complex, etc. But it doesn't make the game feel completely different, other than the fact that it can bring most GPUs to their knees.
Digital Foundry spent way more effort on hyping up the image quality enhancements. Kudos to them. But for every part where they show RT Ultra or even RT Psycho (which generally doesn't look that different from RT Ultra) versus RT Overdrive, there are ten comparisons between Max Rasterization and RT Overdrive. That's because those differences are far more noticeable.
There will be rooms lit up by a light source that look far more "correct" with Overdrive than with RT Ultra or rasterization. It's still the same game underneath, however, so we're putting a bit of lipstick on a pig. Unless you love Cyberpunk, in which case maybe it's a fox. Whatever. If I hadn't already finished the game, sure, I'd turn on Overdrive and play it with DLSS upscaling and frame generation on a 4090. But I don't have a compelling need to go back and replay the game.
The guns still feel the same. The randomly generated people and cars that go nowhere are all the same. The quests are the same. But the lighting and shadows are different! Assuming you have a GPU capable of playing the game.