I have nothing more to add to this Stan other than my own experience of this sort of nightmare - being someone that will and freely gets obsessive over displays and optimum experiences.
I took the jump early this year and plumped for a Xbox X and suitable panel to make the most of it.
The best screens at the moment, as you point out, are the LG OLED ones, so that's where to cast the line.
I had the unfortunate criteria however of needing a panel, originally, no bigger than 30" to fit into my office - which ruled out the majority, if not all of the best panels.
In the end I had to compromise that to 40", as that game a selection of panels that offered HDR10 and UHD4K.
Like you mention I used TVratings as a guide to see the wood from the trees and measure up what TV's were out there on offer that rated highly. Worth noting that as its an American site it can be a pain trying to work out the model codes as they differ from ours but with a bit of reach you can work it out.
Again, like you, this panel was going to be used solely as a display for my Xbox X and PS4 Pro - initially my Switch also. Not a single TV show has splashed its screen.
Long story short, in the end I went for a Samsung MU6120 from Argos, which was on sale for £399.
Which is a UHD4K HDR10, 40" panel.
Now, TVratings, has this as 7.6 out of 10 panel, with its strengths being HDR and ideal for console gaming. Which does me fine and for the price - very good.
**Also, worth pointing out that a lot of people initially first notice the HDR over the resolution, so a TV that plays to that is going to give you noticeable results - me, I'm just sort of used to both now, HDR and 4K and both have their noticeable improves I think.
Downside to the panel I choose is that it has narrow viewing angels, so in effect as you sit to less straight on and more to the side the display can seem to get washed out, this is also applicable to up and down.
Now, seeing as though I was using it in a window-less office, (which used to be an old tally kitchen for scale) at the end of the room, it offered little option other than to it almost directly on front of it, which mitigated the panels weak points.
Another important feature about most Samsung screens is that they have an option to switch on or off HDR for certain inputs. This is important, as having the feature on, for an input that doesn't support HDR can cause issues with the medium is displaying. This is important for the Switch.
I have my Xbox One X and PS4 Pro passing through a Onkyo amp with HDCP 2.2 support, which will pass through the HDR and 4K to the TV, however, I have to plug my Switch into an separate input on my TV, then switch off the HDR on that input to display a clearer image for the Switch.
All these things considered, it was a winner for me and the panel I eventually went for.
Do your research mate, it will pay off in the long run. A good tack is to see what panels you can get on offer or cheap and see how that stack up in the reviews, you'll probably be able to get a 8/10 panel for cheap !
Quick snap of my set up.