Gamestop posts a article about their experience with Overdrive Mode. And well... it goes about as well as you expected along with most everyone else feedback. Here is a snip;
Cyberpunk 2077 developer CD Projekt Red and Nvidia explained that Overdrive mode enhances the game with full ray tracing, which when compared to regular ray tracing, more accurately simulates light throughout an entire scene. This technology has been used on film and TV sets, and with the new Nvidia 40-series of graphics cards on the market, it's now possible to apply those techniques to games. But why Overdrive mode?
This is also made possible with Nvidia DLSS 3, which gives a massive boost to frame rates when the mode is applied. Without DLSS 3, Cyberpunk 2077 will run at around 17 frames per second with Overdrive mode on, but with DLSS 3 active, that number increases to around 128fps.