Games are handling this by dialling the amplitude of RTX effects way down and having a smoothing pass. After all that is done, the wow effect is gone and you're just left with a more dynamic version of the same or worse aesthetics that we're already used to.
I expect it'll truly take off on next gen hardware, whenever that rolls out.
Here's what RTX+DLDN actually looks like if not dialled down and smoothed: https://youtu.be/CuoER1DwYLY?t=553
My takeaway is yes that quake 2 demo looks really cool, but you just know that they used every black magic hack in the book to get there, and most of it can't be replicated in a modern high fidelity game. It's definitely not a case of flicking an 'RTX on' switch.
If you thought the official 3DS one was pretty, wait until you see the fan work done on a UE4 version:
Until you ask them whether a scene is a photo or a render. They won't know to look for shadow acne, but they will still make a judgement that includes it. RTX has a few things that we've had for years, but it seems to do a way better job at energy preservation.
Instead of "wow" you get "well, duh, that's how things should look".