I’ve not seen many RPG maker games mentioned here, so i’ll do my part. These are a lot of my favourites through the years:
There are also a lot of them that i’ve not played but i’ve watched full playtroughs of, like IB, Hello Charlotte, Lisa, … and most recently The coffin of Andy and Leyley
One game i would also like to add is Rain World, which is a 2d survival platformer, a bit challenging, but i would argue it’s also a “metroidbrania” if you know the genre, games that have knowledge as gates rather than keys or power-ups like metroidvanias. Some notable examples are Outer wilds or Return of obra dinn, who others have already mentioned
For story driven ones i liked To the Moon, that others have mentioned, Finding Paradise, OneShot, and The coffin of andy and leyley (which is still ongoing). Some that have combat but are still focused on a story are Omori, and End roll. Almost all games where you go eventually go into someone’s mind, i’m noticing now.