Faster RAM won't fix a data decompression bottleneck, that's a CPU side task on last gen hardware.

Sure.  But the point is the ps4 beats out the S2 in some areas (especially the pro) and falls behind in others.  Too many people on this forum are delusional and act like the S2 is leagues above last gen consoles.  It isnt.  The ps4 and especially the pro are fair comps.  The S2 is way closer to the ps4 pro than the ps5, just a damn fact.  

For the record, I definitely wouldn't say Switch 2 is "leagues" above PS4, though I would say it is better on balance.

It's a case by case thing, where a lot will depend on the game in question; what it's specific demands are, what techniques it uses, etc.

I would put the S2 bang on the ps4 pro.  The ps4 pro had solid upscaling via checkerboarding and power is roughly the same.  Technically the ps4 pro has more raw power, but the S2 is more efficient, it washes out.

Every piece of hardware is slightly different, which is why I think broad tiers make sense, versus subtle nuance.  Like the ps2, GC and xbox..  I would put them in the same tier.  There were subtle differences between the three, but largely the output was close enough.

I think the best way to describe the SW2 is that for 8th Generation -like titles it provides a result about comparable to a PS4 Pro. But when trying to run 9th Generation titles the PS4 Pro would struggle in ways the SW2 doesn't, or to a larger extent. PS4 Pro tier hardware runs a game like Star Wars Outlaws at like 20 fps with FSR 3 Quality @1080p target.  

PS4 Pro wouldn't be able to run Star Wars Outlaws without changing the rendering for lighting. That game uses mandatory RT GI from what I remember. So your example is pretty irrelevant.

Returning to the point, Switch 2 GPU architecture wise is superior to PS5 to some degree. It just lacks horsepower to use all of modern features that can be seen in newer games. CPU wise S2 is pretty underwhelming though. Nintendo should think about releasing an overclocked Switch 2 Pro for people with disposable incomes that want to have the best Nintendo experience.

Yet another Capcom game (Pragmata) looking way better on Switch 2 than Series S.

Series S is a joke at this point, and Capcom refusing to utilize temporal upscaling on Xbox and base PS5 with many recent titles is enabling the Switch 2 to push far above its weight.

Framerate is not good on Switch 2 though. So utimately all the covered versions on DF artificially suck. Capcom should have added a framerate cap on Switch 2 version at 30 and 40fps, and FSR2-3 modes on the other consoles.

Agreed.  The pro lacks RT and DLSS.  HP is very close, maybe in favor of the Pro, but S2 has newer tech which helps.

No, SW:O doesn't need RT hardware (usual misconception), it uses software RT, yes, PS4 Pro would be able to run SW:O (it's GCN4 arch, and RX570/580 are running SW:O) in theory if Ubi put effort into it (but it would require even more concessions than SW2 port), no it doesn't make any sense from business perspective.

Whenever SW2 can use full DLSS model, image quality looks pretty good, especially in games where devs are using only spatial upscaling on other consoles. It is very solid hardware, though it might've been better if Nintendo was not going for higher profit margins.

That was my main point.  A system not getting games does not mean it can be done.  Most ports are a business decision, not executed from a hardware perspective.  Mandating SSD on the ps4/pro is a stupid business decision; however, it could be done. 

(I suppose my other point is the ps4 and especially the Pro are far more capable than I think people give it credit)

Also, thanks for the knowledge share on CPU, much appreciated.