While TikTok and social media have had some affect on our overall attention spans, the way I look at it though tends to be that they are merely the symptom not the cause. After all, attention spans were shortening long before even Facebook was created and before dial-up was even common place. In my opinion I see that companies noticed how to take advantage of shorter attention span but were what started to create them. If I were to hazard a guess then I'd say that attention shortening is the natural state of the human race as the entirety of human history has been consistently filled with the concept of creating easier to consume recreation and media. Even religion can be considered to be apart of this instinctual need to focus not focus on anything that pertains to direct survival for a period. I'd also say that the best recorded and most palatable example of this would have to be in the way supermarkets and grocery stores slowly evolved to be constantly psychologically manipulating the customer, if you ever get the chance it is a fascinating subject.
On the note of visual novels I can say while I do love long term story-telling, especially as it pertains to romance, I have a very difficult time if the story is both heavily emotionally investing and incomplete. I've been known to fall into deep bouts of depression whenever I finish all that has been finished. As such while I can personally recommend both Sileo and Minotaur Hotel as being impeccable, I also must admit that I haven't touched either in well over a year now as I've promised myself to let them either finish or die before I go back due to the fact that my poor constitution simply can't handle the emotional whiplash, for this very same reason fanfiction has become a very rare treat for myself. Two others that I have been following and can recommend are The King's Hound and The Bastard of Camelot, two arthurian non-visual visual novels developed in twine and that were released within the same week. While both are similarly incomplete and feature even sparser updates I can say that I can follow the latter more then the first two due to the latter having a bit less emotional depth, thus allowing the cliffhangers and character growth to be less emotionally devastating to me. On a final note I would highly recommend twine game as while most visual novel readers maybe turned off by their little to no visuals, a lot of talented developer have created beautiful games in the program and it is often a shame how easily they are over looked.
(Also please forgive me for any grammar or punctuation faults, I am currently fighting a cold and haven't been finely combing my writing as usual.)