I've always had a soft spot for the cheesy sincerity of "Faith of the Heart" and its lyrics, but reading over this thread made me realize that it's really a self-congratulatory song that's an odd fit for a prequel series. Yes, I get that humanity has triumphed over its own demons and violent history, and is celebrating that, but the show is about us only beginning to make it into deep space, and as such, a "yeah, we've accomplished so much!" song doesn't really stoke the fires of excitement.
Instead, something much faster-paced than the DS9
and even TNG
themes could have been more effective. Something like the "Can You Dig It" theme
from Iron Man 3