PCSX2's emulation, at this point, is very, very good. There are very few games with noticeable problems.
Duckstation is similar. There are certainly edge cases, but in 99% of cases, games play better than on physical, vintage hardware - and with achievements.
RPC3 is a bit different, because of the complexities of PS3 emulation. But, there's something that people should keep in mind with it - just because RPC3 or the compatibility list describes your game as 'ingame' instead of 'playable' isn't necessarily an indication of the actual state of the emulation. Case in point, I just booted Ridge Racer 7, which was set to 'ingame' in 2021. The game runs flawlessly, I just completed an arcade circuit with no visible glitches. Perhaps there was something slightly off, but to me, it was so imperceptible that I didn't even see it. So, just keep that in mind - the compatibility list is an importance resource, but it isn't always a definitive map of what's working and what isn't.
EDIT: RR #