The author knows that being salty and otherwise obnoxious drives clicks, which is as much how he makes money as the writing in the games.
I'd disagree with Undertale, which is the only one on your list I have played, although I didn't make it far (a few others you mention are on my list already). Of course, there is always quite a bit of personal taste involved in such things.
My list would be something like:
-RiME
-Falcom's Trails series
-My Brother Rabbit
-Rakuen
-Röki
-Higurashi When They Cry Hou
-King of Dragon Pass/Six Ages (particularly the mythology parts)
Maybe also to a lesser degree:
-Amnesia: Memories
-London Detective Mysteria
-To The Moon
Of these, RiME and My Brother Rabbit have no text but still tell a story very well IMO while Falcom's games have tons of text (more than any individual book) and cut some corners in the story but do a lot of things well and you get to interact with a lot of different characters and hear their perspective on the world.
Higurashi When They Cry Hou was IMO unquestionably the best written of them all (which makes sense as mentioned in another thread it is a book with sound not an interactive game), although I liked it least since I don't like horror but didn't realize it is a horror game.
For Fossil Echo and The Journey Down I thought the storytelling was particularly good in how it combines video with the game but the story itself was not all that good and the games themselves were disappointing IMO. I think I would put The Longest Journey in a similar category also (and likely Sibera, although I've only played a bit of it).