Metroid Fusion carried on the story of Super Metroid. There are three Castlevania games that take place after SotN, two of which feature Alucard. Chrono Cross carries on the story of Chrono Trigger.

There are plenty of games to which I'd like to see sequels, but I can't think of any games that bothered me with unresolved stories.