If that's what you care about then buying a modern console is a terrible idea, however you can buy a "retro" console (xbox 360) with dozens of games ver practically nothing (The first match on gumtree near me was a 360, 2 controllers and 35 games for £60)
On PC they even have BotW DLC. https://www.nintendolife.com/news/2021/03/introducing_second... there’s no comparison for functionality.
The new Xbox can emulate (very poorly, less than a weaker computer can, but it’ll get better) too, it’s why the xbone with dev mode for homebrew was never hacked. https://www.ggrecon.com/articles/emulate-playstation-2-xbox-...
If I had to buy a console, form factor is the most important, I love my PSP. Could play NES, some SNES and very slow N64, perfect compatibility PS1 emulator, GB+GBC,GBA and of course PSP games. The homebrew on it for apps was amazing too with music players, ebook readers, cheats for every game, ability to change clock for battery life or performance, really a game changing device.