PCSX2 recommended system requirements are fairly low. Core series or Ryzen CPU, 4GB RAM, and GPU with DX11 support . But yeah, not all PCs are going to perform great, but any PC the last few years should be able to run it fine.
The PS3's Cell processor was extremely complex compared to traditional CPUs and Sony decided a while back to put no effort into emulating it, apparently. This is a big reason why PS Now exists. I expect Sony is dedicated to that service for everything regarding PS3.