Handheld Gaming options? I’m unsure how downloading apps works in these

I’m looking for a handheld gaming system, between 100-200€ if that’s possible (secondhand is okay). I would want to use PS5 remote play but also have the ability to play games locally, maybe some retro emulation, when I’ve no internet (or power considering this weeks events). If anybody has some recommendations I’d appreciate it!