Microsoft Flight Simulator and Cyberpunk are the only games I can think of that go out of their way to lean into various things like DLSS and RTX and the cards make a huge difference.
Callisto Protocol is out in Dec, God of War 2 also but thats PS5 only for at least 2 years, other than that not sure what else is out in 2023... Starfield will be optimized for Series X, then there is stuff like FF7R part 2 (is a PC port at launch?), Jedi Fallen Order 2, Final Fantasy 16, and FF7 Chrono whatever. I'm pretty sure all of those will run perfectly fine on anything really.
Star Citizen is the 4090s only hope but by the time it comes out the 6090 will be out