Witcher 2 had the best story. Since the gameplay was so dogshit I only played it once, but I think the story that I got was really kino. The reason why I love it is because you are playing a background character, it's like if Huncback of Notre Dame was written only from Pierre Gringoires. In the third chapter I couldn't choose to help Iorveth, simply because that would mean abandoning Triss to possible death l, which is something neither the character, neither I as a player would allow (now after watching a review on yt I learned that this choice is actually pointless and you are an idiot for not helping Iorveth/Roach, but I didn't knew it when I played). This then leads into a total failure of everything secondary you tried to achieve. I mercy killed impaled Saskia, someone I tried to help before, and then, leaving the city with Triss, saw Iorveth, my friend and ally, dying by the side of the road. Then came the confrontation with Letho. This was where the game was leading me to, where Geralts story went. All to pursue a killer of some inbred kings, who was motivated by wanting to protect his "family", who I knew where dead at this point. He caused all of it, but I just couldn't see him as a bed person, nor someone I should be motivated to fight. So we let each other live. A small kindness after all the killing and death And the final touch - the ladybug scene - of Geralt showing gis gentle side even if for a moment, felt perfect to finish off the story.
Now as for W3, I like to say this about it - in a sensible gaming industry that isn't fucked over by capitalism, W3 would be an 'aight game. It doesn't do anything special in gameplay, the world is ok I guess, its polished and big, and the story while not bad, is only servicable. It manages to feel like an adventure, which is good, and the itemisation and crafting did a lot to make it engading, at least for me as a WoW player. Also the characters were pretty great as well, and there deffinetly were humanizing scenes.
The second dlc, BnV, was much the same. Really the main higlight is Regis, who deffinetly feels like your good old friend.
However Hearts of Stone is really good. The story might not be as emotional as W2, but it is deffinetly intiguing and fun, as well as highly creative. Its a linear experiance and all the better for it.
Sadly didn't play W1 since my pirate site didn't have it.