This is a really good post, and I think it gets to the core of what I think is one of the things people are missing about Veilguard - it's just a different type of story.
In Origins, you play as one of the two people in the country who can save the world. You are fighting impossible odds - you and Alistair and the mishmash of people you've managed to recruit - against a ceaseless mass of mindless creatures. Not only are you fighting darkspawn, you're fighting against the system, controlled now by a man who sees his fears around every corner. Depending on your Origin, you may feel more strongly about certain factions in the game, and by the end you can feel hope for the future as you ask for a boon (self-governance for the Circles, or land for the Dalish clans, or a noble seat for the City Elves). It's one type of fantasy - and it's a good one!
In 2, you're playing as a hopeless refugee, who manages to build something for yourself through hard work. But the core of 2 is that in the end, it didn't matter. Nothing Hawke did ever mattered, because you still lose basically everything, and even if Hawke wasn't there, and did nothing, things would play out the same. Things in Kirkwall would have come to a head, Anders would still have blown up the Chantry. It's another type of fantasy, and a particularly dark one on a personal level, imo.
In Inquisition, you're someone who was in the wrong place at the wrong time (or arguably, the right place at the right time), thrust into a leadership position you didn't ask for but that you have to take. In some ways it echoes Origins, with you and your allies standing against people in power, but the difference is that you can accumulate a significant amount of power and become a force to be reckoned with. One again, a different type of fantasy for people to enjoy.
Veilguard is once again a different type of story. It's about saving the world, yes, but it's also about making that world a better place to live in, both in small and large ways. It's a story about hope in the face of hopelessness, looking to the future in the face of loss. It's about acknowledging your regrets and your failings, but getting to your feet and saying "I can do better."
And for me, that was a really cathartic story. Being positive and hopeful doesn't suddenly mean it's sanitized, and it certainly doesn't make the writing bad. It's a different type of story.
And it's okay if that story doesn't resonate with everyone! Not every story will! It's okay to look at something and go "that's not for me, thanks." The problem for me comes when someone looks at something and instead of going "oh I don't think that's my thing", they go "I don't like this thing, which means it must be objectively bad".
I think it's honestly a symptom of a bigger problem in wider fandom spaces, how they've evolved into this less nuanced place where some people seem to think it's unthinkable to go "no thanks, not for me".
It's okay to just dislike something. Veilguard being different doesn't erase the joy you found in the other games.