I’m firmly of the opinion that, overall, the newer the LEGO game is, the better it is, because they’ve been figuring out ways to break up the essentially boring as crap gameplay with humor and other elements.
By this metric, Lego Lord of the Rings is better than Lego Harry Potter. Also, can Lego Harry Potter do this? I didn’t think so. 
Sorry, but the “console adventure game” is a category that was created after the fact. Zelda was originally marketed as an RPG, and only after RPG became a much more static concept did people start to say it wasn’t one.
I personally reject the title of “adventure game” being given to any title that is action oriented. Throw in the fact that the game has items, dungeons, upgrades, and even technically levels (even if they aren’t called such outside of Zelda II), and the game is either an RPG or a platformer. And it is definitely not a platformer.
To say it isn’t an RPG would be to deny that most modern non-JRPGs are not RPGs.
It’s Not an RPG. It’s absolutely an Action game. Regardless of what you think those genres should be, what they actually are, excludes Zelda from the RPG category.
Put it this way: If Zelda is an RPG, so is Mario. So is Metroid. so is a LOT of other stuff that no way in holy diablo cow level hell belongs there. It pretty much becomes a catch all term for a ton of very different games and stops being useful as a descriptor.
Because it’s totally against the rules to create a new genre for a game that was originally conceived as a blending?
Yes, Zelda is kinda like an action RPG, but action RPGs don’t have the puzzle solving aspects of Zelda games, and are much, much more focused on…action and combat. (Ys: Origins would be a fine example of a ‘classic style’ action RPG.) The fact that Zelda was or was not “marketed” as an RPG means… well, nothing to me, really. Nor should it to anyone.
But it doesn’t have “levels” in any of the classic senses. And ALL adventure games have “items”. It’s obviously not a platformer, as there are no platforms (Most clearly defined genre ever), but it contains far more puzzle solving than an RPG, while being far lighter on RPG systems than an RPG.
Where does Quest for Glory stand in your mind? Because that is WAY more RPG than Zelda, but is generally accepted as an Adventure Game.
There are so many negatives in that sentance that I literally cannot parse it. 
Good list.
I’d throw Amnesia into the adventure game category. It’s first person, but it’s not a shooter.
There are a couple Walking Dead games out. The one that’s an adventure game is from Telltale Games. It made several top 10 lists, and for good reason. There are action sequences, but they’re very forgiving of failure and don’t fall into a trap of being too frustrating.
Indigo Prophecy/Fahrenheit is on Steam, so it’s not hard to find at all.
Wow! I am blown away by all of these suggestions! I’m going to start checking them out one by one. Thank you SO much!
FWIW, I really liked text-based adventure games back in “the day”, and I played old-school golden zelda cartridge until my ears bled. I also liked Maniac Mansion, but needed an old magazine walk-through to complete it… dern. That felt like sweet, sweet failure…
What’s a “JRPG”?
Japanese RPG, referring to the Final Fantasy style of game.