To be honest, I Love 'Faith of the Heart'. It did not surprise me that people hated it, but for me it perfectly fit the theme and feel of the show.
Also, as someone who loves the philosophy in Trek, I felt it SAID what all the other themes did. I enjoyed the poignant feel of the song. We dont need silly 'gods', we can overcome our inadequacies, we can 'reach any star'. It actually gives me tingles and I find it rather motivational. That, however, is a personal take on it.