Old post, but consoles imo aren't really relevant if the console itself doesn't try to fill in some niche. Desktop consoles being just glorified and extra locked down computers make them pretty bland. Physical medias being actively killed (to my understanding) for nearly 2 decades now (and not just dying out) also kills another part of the novelty of consoles. And the games that are used to promote them, I often feel tempted to call AAAsset flips (more recycled ideas than assets tbf but the tiredness they give is the same as the opposite).
Meanwhile, the best consoles imo right now are the portable ones, since I can play wherever I want, in Nintendo's case there's still a nice influx of physical medias, in the portable PCs and portable SBCs' cases systems that support even Steam and the sort are appearing, and generally the libraries you can find in those goes more for just being fun, even when in lack of exclusives.