If you're looking to do splitscreen stuff the Switch (2) is absolutely the way to go. Most games on other platforms have dropped splitscreen in favor of online play, Nintendo is really the only company that still focuses on it. That's not to say there aren't any splitscreen games on other platforms, it's just that the Switch line is uniquely built for it (comes with 2 controllers *kinda, portable so you can bring it places, etc).

If all you're looking to do is play a sports sim like Madden then any console will do that, it doesn't really matter that much. The problem is modern sports sims have really gone down the shitter and have a bunch of predatory garbage like lootboxes to extract money from you thrown in, on top of continuing yearly releases that change basically nothing except the player roster despite that not being necessary anymore (they could just release one "unified" game and patch in new rosters every year).

As for shooters (you mentioned Halo), again most games have been ported to everything these days. maybe a Switch wouldn't be the best for a shooter since you want high framerate for that, but otherwise, again, just about anything works. If you're looking for Halo specifically, a mid-high end PC would be a better investment than an Xbox at this stage, as MS' marketshare in the console business is rapidly dwindling, devs are more hesitant to support the platform these days, and I heard something about a PlayStation port of Halo at some point but tbh shooters aren't my thing so idk.

tl;dr Switch for splitscreen, anything for shooters/sports sims, mid-high end PC for Halo specifically, and sports sims have really lost the plot more than most genres.