If you wanna play games like Mario, Pokémon, Kirby, or The Legend of Zelda, or if you enjoy multiplayer games with people in the same room, the Nintendo Switch is the choice. However, keep in mind that the Switch 2 is expected to be announced between now and April 2025. This means the price of the original Switch will likely drop, making it a good time to upgrade from the Lite (and there may be backward compatibility, so waiting could be beneficial)
But if you're looking for games with high-end graphics, big adventures, and more online multiplayer options, etc, and you don't mind missing out on Nintendo titles, I recommend choosing a PlayStation over an Xbox because their exclusives are better imo. However, Xbox consoles tend to be cheaper. If you have the option, get the disc version of either console so you can sell your games once you’re done with them. With digital games, you only purchase a license and don’t technically own them (which is something I feel strongly about lol)