There's something anti-climatic about No Prayer.
Regarding the aspect I believe holds back No Prayer, I think this remark is extremely well spotted and superbly synthetized. And, IMO, it was amplified by the fact the record came out only two years after Seventh Son Of A Seventh Son, easily the most pompous and theatrical album Maiden has ever released. SSOASS's "wow!" effect is surely on high... a trait Maiden increased from album-to-album during the 80's and NPFTD's major strength isn't based on that premisse IMO (TBH is quite lackluster in that regard).
I bought the record the day it came out and, although I liked it, from day one I felt a certain disenchantment attached to it and that lingered for years. TBH, during a couple of years after 1992, I was even more drawn into FOTD than NPFTD and that stems precisely from that "anti-climactic" factor: despite being a filler fest, I'd much rather listen to the by then "brand new" FOTD stand out tracks, like "Be Quick Or Be Dead", "Afraid To Shoot Strangers" or the title track, since they're arguably more appealing and exciting compared with the best tunes on NPFTD. IMO most NPFTD tracks are extremely enjoyable, yet none of them goes all out in one particular aspect. In other words: there are fast and heavy songs yet nothing like i.e. Iron Maiden, Invasion, Sanctuary, Killers, Purgatory, Murders In The Rue Morgue, Back In The Village, Sea Of Madness, Only The Good Die Young or Be Quick or be dead. PENO, the title track or Mother Russia have excellent guitar harmonies, yet I can easily and immediately list at least ten songs that are more effective in that regard. And yes, Tailgunner, Fates Warning and Run Silent Run Deep are great muscular metal songs but once again there are several instances when the band had similar compositions that, in my book, are better achieved. And when it comes to epic flavor the difference is even bigger. The sole aspect where I think NPFTD 100% matches any release is when it comes to the radio hit song: despite its corny lyrics and polarizing as it may be, Bring Your Daughter To The Slaughter IMO is on par with Maiden's best hit singles (or slightly below some) like Running Free, Wrathchild, Run To The Hills, Flight Of Icarus, 2 Minutes To Midnight, Wasted Years or Can I Play With Madness.
NPFTD is surely a slow burner and it's not for everyone. And it's easily mistaken for uninspired and mediocre if it's given little spins. During the 90's I listened to it aplenty, yet I always thought it was a truly subpar release. It took me more than a dozen years to give the album what I believe is its due value. Ever since I consider it to be a really cohesive effort. With the exception of Hooks In You, there's not a single song I dislike. There was an evident effort from the band to strip down their sound a bit back to their roots (making what would be somewhat of transition between Killers and TNOTB ) but I believe this goal was somewhat of a misfire: most of the songs are indeed more straight forward yet they lack the sheer aggression of some cuts from the Di'Anno era. On the other hand, it brings a more polished and intricate overall approach, yet failing to be on the same echelon as the more curated compositions present in its Dickinson era predecessors in this regard. Like I use to say they somehow got caught in no man's land, and IMO that's precisely what gives the album that "anti-climactic" feel to it, soundings somewhat "tamed" and even lacking ambition or pretention in a positive fashion.
That being said I must underline how I came to enjoy NPFTD way more with the passing of time. Do I still believe it is the band's least achieved record up to its release date? Absolutely. On the other hand, it's a rock-solid album, arguably lacking masterpieces yet IMO it's filled with great tunes, really easy to listen to and it's far from being my least favorite Iron Maiden record. I would even say that, in a paradoxal twist, the aforementioned "anti-climactic" feeling gave the album a unique aura among all Maiden releases. And, unlike back when it came out and the following times, every time I give it a spin, I find myself having a ball listening to it.