Actually, I thought the best part of the game was Link just going back to his normal life, just going back to Ilia.
In most of the games, Link's an outsider - he doesn't belong anywhere really. At the end of the game, he leaves for somewhere because he realises he doesn't belong.
In TP, on the other hand, Link's part of a community. He's got a job (farmhand), he's the apprentice to the local swordsman, he's engaged (well, it's implied anyway), and he acts as an older brother figure to the kids in the village.
Hell, the whole game is initially motivated by Ilia and the kids being kidnapped. Everything goes from there. Admitedly, once you save them, Link's in too deep to stop, but it's still all about Ordon, and Link's mainly motivated to keeping his family safe (or at least, so Midna indicates).
Zelda's too distant from Link in the game to be a real love interest. I mean, she meets him twice as a wolf, and afterwards, she dies. They don't even get a chance to talk or anything. When Midna revives Zelda, there's a spark between her and Link - but it's only the lust and adrenaline because they just kicked Ganon's piggy ass. They're too distant, too different to be connect - Zelda's too ingrained in Hyrule culture, and Link's too far outside it to care.
And, finally, Midna. I just get the feeling that they were too close as friends and travelling companions for anything to happen, y'know? Not only that, but when they first met, the first impressions given weren't the best. Midna looked like a six year old girl, and Link was a wolf. Even with both returned to normal, and everything "resolved", there's still the issues. I mean, what if half way through orgasm, Link suddenly remembered what Midna used to look like? Awwwwkwwwwaaaaard.
So, yeah. I'm actually pretty happy with the ending of the game, and I think it ended in the best way possible. Link being noble and staying true to himself and Ilia - and not giving into lust'n'stuff.
