I don't really consider Zelda to be an RPG (I mean, the genre is often called Action RPG, but it's really a different beast).
Anyways, one of my favorite games of all time is getting a remastered release on the Switch in May--Xenoblade Chronicles: Definitive Edition
Everything just comes together in that one. Great story with twists along the way, really like the characters and the chemistry between them, great and varied environments to explore, really cool concept of a world where you live on the bodies of giant dead robots.
Highly recommended when it releases. It should eat up a fair amount of your time, too. I understand that if you try to rush through the main story, it's about 60 hours. I put about 180 hours into my first playthrough and there were still more sidequests to do. There are also some super-monsters to fight that are over-leveled (you probably want to be around level 80 for the final boss, level 99 is the max level, and Avalanche Abaasy is level 120).
Battle system is kinda MMO-like where you've got auto-attacks along with arts that have cool-down periods, but it's definitely a system where you've gotta adapt to how the battle is going and strategize unless you go into fights over-leveled.
If you wanted something more immediately, there's the (spiritual) sequel, Xenoblade Chronicles 2, but while its world-concept and gameplay are very similar, the themes of the story, as well as the style of story-telling are pretty different. I personally don't care for the characters in this one much as they're pretty flat (except in the chest which is disproportionate, unnecessarily revealing, and cringy camera angles focusing right in on it even at the most inappropriate times) and generic. The main character in particular doesn't seem to have any reason to be motivated for his quest. I also don't like the combat as much which is again similar but different. It has a lot more momentum in it where everything starts small but as the fight goes on the damage snowballs and grows exponentially, but by the time your ability to damage grows enough to be real potent, the fight is already over anyways*. But, all that aside, it really does have beautiful worlds and great music. Some people do prefer this one to the original, so do your own research on it to see if it's up your ally. For the most part, the two games are completely separate, but there is one scene in XB2 that tangentally connects it to XB1 (and might constitute a little spoiler for XB1).
There is a Prequel DLC/Stand-alone physical game, Xenoblade Chronicles 2 Torna: The Golden Country, which in my opinion is a far better experience than XB2. Much better cast of characters with actual motivation and chemistry, less cringy stuff (seriously, XB2 can be down-right embarrassing to play with other people in the room), improved pace of combat, etc.. It's definitely a smaller game than the others, but it's by no means a small game in general. It contains contents that would play spoiler to what happens in XB2, but the same can be said where XB2 contains content that would spoil what happens in Torna, so it's up to you whether you want to jump into this before playing XB2. Apparently it was originally planned for this stuff to be played out after--I wanna say--chapter 7 of XB2, but it grew too much in scope and had to be broken out into a separate game, so that is another way to play: start XB2, play up until that point, then play Torna, and then go back to XB2.
For a different kind of RPG, there's Fire Emblem: Three Houses, which is a Strategy RPG, so it plays out like a game of chess; at least on the battle-field. You'll spend a lot more time running around campus than in battle, though. You play as a professor at an academy teaching students to become warriors. You can guide them to proficiencies in skills that will make them most useful to you on the battlefield. You will choose one house to be the teacher for, and the story will play out based on which house you are with, so it will take multiple play-throughs (and each play-through is a decently long experience) to get the full story of the conflict from all sides.
Speaking of Fire Emblem, there was a Shin Megami Tensei/Fire Emblem Crossover for the Wii U that got ported to the Switch called Tokyo Mirage Sessions #FE. It plays like a Persona game with Fire Emblem characters taking the role of Personas. It puts the J in JRPG. Seriously, I've never played anything so Japanese. There are extra-dimensional monsters coming into this world and feeding on people's "performa" (as in the ability of performers such as actors and singers). You work for an organization dedicated to fighting these monsters, but you put on a public front as a talent agency hiring performers to fight these monsters through their performances without the public's knowledge. The game delves deeply into the Japenese Idol scene. There is an issue of censorship in the game, unfortunately, as they decided to censor and entire storyline that was supposed to be about one of the characters' discomfort about doing a gravure model shoot. I don't recall what it was transformed into (I played a version that brought back the original Japenese version of the storyline), but I'd read it didn't make much sense.
Anyways, the battles play out as a turn-based battle where you'll select an attack to perform against an enemy, but some attacks can be chained together with attacks from other characters allowing you to build damage by trying to keep a chain going. Eventually some characters will take part in a side-quest that ends with them learning a "duet" in which they perform an attack together which starts to really nipponify the battles, as they'll actually put on a performance in the middle of battle.
As I said, very Japanese.
Then there's Dragon Quest 11S. I can't give you a big run down on this as I haven't played it yet, but it's supposed to be a big expansive JRPG with classic turn-based combat. People have had very nice things to say about it. Also, it included the ability to switch between playing it as a 3D game and 2D game.
There's Valkyria Chronicles 4 (also the original is available digitally), which is set during a WWII-type conflict in an alternate universe. It's similar to Fire Emblem in being a strategy game, but it plays very differently in that instead of being grid-based, you get a set amount of "AP" to move a unit during a turn where you run around in a 3D environment to get into position and fire upon your target. But if you enter the range of enemy fire, they will fire upon you even though it is your turn. You manually aim your shots, but you do not have perfect accuracy; different weapons will have different levels of accuracy, so even if your crosshairs are on someone's head, you may get body shots or miss entirely, and they can dodge. You can take cover behind sand-bags or lie prone in grass to stay hidden. Definitely an interesting take on the SRPG genre. Pretty anime-like story/characters for the cut-scenes, whether you find that a positive or negative is up to you.
I'm just confused. I thought a real console was one that brought you a unique experience with games tailored to the platform rather than something that gave you the experience of a low-end PC but with fewer games and without the modding scene.