Its weak CPU makes games like BG3 unplayable, despite Digital Foundry claiming that low 20 FPS in the city is 'fine' (it feels like they're just promoting it blindly). The GPU is also lacking, and it relies on brute force rendering, making it pale in comparison to a decent PC with DLSS. The upcoming PRO seems equally underwhelming. A slight boost in CPU frequency won't solve the underlying issue of the weak CPU, and a moderate GPU enhancement won't compensate for the lack of features like native AI upscaling.
The hardware is not really the issues here. There is simply no way to make a economically sound console that will not eventually get winded from some future game. The PS5 was a perfectly fine piece of hardware when it was launched, the problem is that it was launched into a fucked up market.
Said fucked up market being the result of the biggest historical mistake console manufacturers and game publishers have made in recent memory, the merger of the PC and console markets. Before the 7th gen of consoles very few games were truly multiplatform and there was a very good reason for that separation. Having two explicitly separate markets meant that say the PSX did not have worry about whether its meeting the technical standards set by Quake or have some sort of app to compete with Thief. It meant that games could be designed specifically for the controller and the specs of the machine and be impressive within that context.
Did anyone really care that SOCOM ran mostly at below 30fps? No, maybe some but hardly enough to matter.
Did FFXII have to explain why it has fewer sidequests than Gothic 2? No, because while both are RPGs they targeted entirely different demographics.
Did Golden Eye have to justify not supporting mouse aiming in multiplayer when Duke3d did? No, that straight up did not even cross anyone's mind.
However if the markets were merged back in the 90s all of these, admittedly stupid problems, would be something the devs would have to tackle. People have limited amounts of time and money and as such will be by default looking for the best way to spend both. In the case of consoles and videogames this means that when they can clearly see that no only they are not getting anything substantially better with the PS5 and in some cases get a markedly worse experience the choice is clear for them.