I never minded having "Faith of the Heart" as a theme song, though I tend to agree it's a bit on the cheesy power ballad side. But I always liked the idea of breaking away from TNG/DS9/VOY-era Trek
's addiction to instrumental themes. It was a good idea for Star Trek
to try to break away from its cliches and to maybe be a bit edgier, a bit more rock'n'roll. I didn't care for the execution, but I liked the concept.
And a memorable theme song can be a great way of setting the tone of a show. There are numerous examples -- Alabama 3's "Woke Up This Morning" on The Sopranos
; RJD2's "A Beautiful Mine" on Mad Men
; the Dandy Warhols's "We Used to Be Friends" on Veronica Mars
; Joss Whedon's "The Ballad of Serenity" as performed by Sonny Rhodes on Firefly
; the Doctor Who
theme by Ron Granier and Delia Derbyshire; Nerf Herder's Buffy the Vampire Slayer
theme; Darling Violetta's Angel
theme; "Gayatri" by Richard Gibbs on Battelestar Galactica
; the X-Files
theme song; etc.
The key is to be creative; the problem with most of the Berman-era music is that it was all designed not
to be creative, not
to draw attention to itself in any way. To just be forgettable and bland. I mean, heck, if they had
to stick to something instrumental, they could have at least gone for something like W.G. Snuffy Walden's theme for The West Wing
So I give them credit for the idea of breaking out of Berman-era cliches, but deduct points for picking the blandest, most forgettable power ballad they could find. They tried to break their bad habits but fell back into them.