A story and characters is totally subjective and depends on a persons view point. I can be the cool guy and like the witcher 3, I can be the anime dork and love xenoblade 2, I can be the awesome gamer girl and love tidus and yuna in ff10, I could be the uber science fiction geek who demands star wars kotor is the only TRUE star wars game. On and on.
Right at the moment I'm playing dragon quest 11s and really like the story/characters/writing. I've also been staring at the case for Xenoblade DE and remembering how much I liked the story of Shulk and crew.
Yup, very true. As an example, Witcher 3 is always mentioned in lists like this, but I didn't connect with Geralt and his story at all. I can't even remember what it was about. He just seemed like another gruff, stoic white male protagonist to me. lol, I'm kidding with that, don't get triggered -- but his lack of expressiveness and isolated, tough-guy persona was part of why I felt detached from him. (Yes, I know it's genetic, part of the backstory, etc.)
I never really connected with him, and, as a result, never cared what happened to him. I acknowledge that the quest writing was competent and more complex than you normally get, but because I didn't connect with or like the main character, the game was mostly a mechanical exercise for me -- leveling up, exploring the world, fiddling with combat. I didn't care about what happened to Geralt or his cohorts. Like I say, I don't even remember what the story was about. Just didn't register.
Anyhow, that's all to say, yes, all of this is very subjective. Who you *click* with, as a character, is a very individual thing.