I still remember FF8 terrible love song. It's like, I'm still having nightmare of that thing at night.
But the intro song, Liberi Fatalis I think ?, was okay.
Overall it's hard and generally pointless to put a song in a videogame, I think. It CAN work but it's often distracting.
It's perfect in Transistor, but hey, Transistor main character is a female singer, so it fits the theme!