I don't think you'll get a mini PC that can play PS3 games for under $500.
However, this guy apparently makes good videos on mini PCs: https://www.youtube.com/channel/UC_0CVCfC_3iuHqmyClu59Uw
Not sure if he might've found one that's cheap, but I'm certain you could find something that fits your needs.
"NintenDON'T sue me please haha"
Can anyone recommend a good mini pc that is powerful that will play up to ps3 games? I need a small form factor pc that is under $500 for work & play. I've always been a console gamer and complete pc noob.