Even with a steam deck, I am probably going to get the Switch2, mostly because I can lower my head on in-game profiteering, which is increasingly prevalent on steam games.
You can absolutely make a game to the quality of Zelda as an indie developer.
Not as enoirmouus as paying a studio in California to make a failed GaaS shooter service. But still a large step past a AA budget.
I'd say at the bare minimum you need a very solid staff of 5 to pull it off though. Hollow knight did it with a rough core of 3 devs + composer (and other support, of course). The very ambitious Toweers of towers of aghasba was reportedly 6 devs IIRC, but that's TBD and might have scaled up.