There's a place for both, but I don't like it when a handheld tries to be a home console. There's so much you can take advantage of with a portable form-factor that you otherwise couldn't with a stationary box. The DS line is perhaps the best example of this with its various features from Pictochat, Streetpass (I miss Streetpass so much) and Download Play. The Switch in comparison, I get what they tried to do in the beginning, but I feel trying to make it the flagship "home console" really compromised it in terms of being a portable console. The elephant in the room is that it may as well be the size of an elephant compared to the DS. And good luck getting the Switch 2 in your pocket because that's even bigger now; you may as well get a Steam Deck for that size and price (it's literally cheaper, lol).
I'm sure there's a lot of people who'll champion for PC over console. But one thing I think you miss on that front is convenience. You don't need to set up a home console in the same way that you set up a PC and you don't need to maintain it as much, either. And as someone who uses a computer for work, I would rather have my PC set-up and dedicated for work. I don't want to waste several gigabytes that I would otherwise have on a Steam library that I barely even play.