Pretty long review, slide at the end for a TL;DR version of it
In terms of overall power for a gaming console, the PS5 Pro does deliver in that front. The specs are better, ray tracing has its improvements, and the inclusion of the exclusive upscaler PSSR helps enhanced most games to better image quality alongside still mostly maintaining the high framerates that most people prefer. The list of games that are pro enhanced was admittedly small back at launch, but it has gained some more options overtime and for the most part, benefits from the pro. Final Fantasy VII Rebirth and Stellar Blade looks and performs amazingly with the pro, Marvel Rivals has near stable 120 fps, and playing Spiderman with the combination of upscaled 4k and the high framerates of 120 fps never felt so clean. There are some games that do perform/look worse on the pro unfortunately, Silent Hills 2 at launch had so many flickering on the textures that somehow makes the base PS5 look better in comparison and Jedi Survivor at Pro launch had so many image issues. Despite this, for the most part, the pro enhanced games do benefit from the improvements and the games that don't use pro enhancements still benefit from the CPU upgrade, especially with dynamic resolution now hitting above or at 1440p in intensive moments instead of close to 1080p. With these upgrades, it may sound like a no brainer to upgrade, but this is a double edge sword moment for this console. The elephant in the room here is the price tag of $750 (at the time when I bought it, it was $700). Its a very steep price when compared to the base PS5 and its $450/550 range. And for whatever reason, there's no disc drive as its sold separately for $80 and in the case you prefer your console vertically, the stand will cost $30, overall making it $860 if you really need all those accessories. And with the RAM situation going on (as of 01/14/26) it may even go higher. Another issue is that its really meant for 4K TVs and/or monitors since the Pro's benefits are mainly meant for 4K. Anyone with 1080p or even 1440p (depending on certain games) are still better off with the base PS5 as its still powerful for those resolutions with high framerates. If you're looking for a powerful console that has some of the benefits that gaming PCs have, this is a good console to buy for that. If you already have a base PS5, I recommend looking at the list of enhanced games before you decide if you should buy or not. If you don't like steep prices, go for the base model. If you don't a 4K TV/monitor, the benefits won't really stand out. If you like buying physical games, really keep the disc drive situation in mind before you buy.
TL;DR: The current most powerful system that mostly delivers with a steep price to keep in mind