So far the only game I've really found RSR to be useful for (beyond just checking out) on my system is Far Cry 3. Far Cry 3 is still strangely demanding at high resolutions, and bumping down the res a bit allows me to push all other settings to ultra and maintain high framerates. RSR adds a bit of crispness that was sorely missing when I bumped the resolution down without it. Maybe I'll finally give it a play-through?
I'm running a mid-range AMD gpu (6700xt) on a 144hz 1440p ultra-widescreen. It's plenty powerful enough for most everything I throw at it... although I admit I rarely buy new games, so I haven't tried Elden Ring or God of War or anything like that.
Doom Eternal can definitely chug with RT enabled, but it already has really great dynamic scaling built in, and RSR isn't really much of an improvement. I think I prefer just turning RT down low and running at full resolution.
I've been playing with RSR for VR, and I think there's alot of potential there, but definitely needs a bit more testing.
So RSR is a good feature, I'm glad to have it, but honestly has limited functionality unless you're running on a low-end GPU or trying to run cutting-edge games. I imagine this kind of stuff is going to be amazing for people playing on laptops though.