I can't speak on most of those emulation handhelds but I have a Miyoo Mini Plus and after replacing the OS with OnionOS its honestly pretty fantastic for how cheap (I think I paid something like $50 USD for it?) it was. It plays most systems up until the PS1 pretty well. Even games a lot of emulators struggle with for certain consoles, like DDS Megami Tensei 2 and Lagrange Point on Famicom, ran essentially perfect. The only issues I really had with it were strangely MSX system based games which is fine if you're just focusing on console and CD games up until the Playstation. It even played a lot of the MAME arcade games I threw at it, PC engine CD, and Sega CD games perfectly. But if you want to play anything past the PS1 I heard that the Retroid and Anbernic lines are pretty good, just a little bit pricier.