To start with one that shouldn't have ended where it did because it actually is unfinished, and no sequel was released either, Anachronox.
Then, things to be said about Betrayal at Krondor (by the end I was too focused on tedious things to eke any last bit of improvement for the characters, but nevertheless I felt quite immersed in it and there was that feeling of playing a book...), King's Bounty: The Legend (sure, they made plenty more after it, and I'm yet to even play Armored Princess, which is supposedly the other good one, but that changed things too and I liked how that one worked quite a lot, the gameplay itself), Might and Magic VI (again, liked the gameplay itself, though by the end, when it got to the sci-fi part, it didn't feel too right anymore, so maybe say that I didn't want it to get there), Quest for Glory 2 (replayed this lots of times back in the day, could have sure used more of it instead of replays, and next ones are different, but of course it was a matter of limited access to games then) and Vampire: The Masquerade - Bloodlines (I mean, come on...).