Similar discussion going on here -
https://texags.com/forums/30/topics/3578734This has become a BIG niche hobby and there's some awesome options out there. I'd recommend checking out the SBC Gaming Subreddit at the first link below and also the master spreadsheet that is maintained by some trusted contributors at the 2nd link below. That master spreadsheet will show you what devices are capable of emulating system wise plus other specs like screen size and price.
SBC Gaming SubredditRetro Handheld Master SpreadsheetI wouldn't recommend picking anything like this up from a drop shipper, you're gong to pay way more than you should. Buy directly from the manufacturers or AliExpress if you want to pay the right price. Amazon is a decent option for some devices if you want them quick and are ok with a little bit of a markup.
Also, PS3 emulation is really demanding and complicated. You'll only be able to do that well with some of the x86 handhelds and you're looking at probably $500+ to get there, unless you go Steam Deck which is a bit cheaper. If you drop your PS3 requirement you'll be able to get something way more affordable.