I suggest RT on consoles is going to be extremely minimal. Like shadows only or a couple of puddles.
You can use your sliders all day long to add more rays or whatever, but if the consoles aren't going to make much use of RT (if) then don't expect your 3090 to transform the game into a fully ray traced RT showcase.
Whatever (minimal) RT gets added to console games, the 6000 series will be more than capable of dealing with it.
I just expect the amount of RT added to games to remain minimal this console gen. We'll need the Ps6 (or beyond) to get a really extensive amount of RT in games.
Your 3090 might look a tiny bit better, but unless nVidia invest heavily - basically paying the devs to fuss over RT for PC gamers - then I wouldn't expect much in the way of RT this console generation.
Like I said, a few shadows here, a few puddles there, and that'll be about it.