Persona 4 with Naoto. If you go that route with her it is absolutely wonderful.

Vayne and Nikki from Mana Khemia also plays out well.

The vast majority of love plots in RPG's just kind of fall to 'meh' for me though.