Only gameboy and gameboy advance. DS and PSP have wifi.

Those are normal choice BUT i would recommend something totally different 😊

There is company called Anbernic. They have a lot of different types of handhelds loaded with emulators. They even come with SD card (if you chose options) with tons of games so you don't have to get ROMs somwhere. You just have to search for model without WiFi. I can recommend a YT channel Retro Game Corps. I think he reviewed all of them and more.

Hope this helps 😊