I've actually had this complaint about modern game music in general. Very rarely do I find songs that I actually notice in games, though that's for a few reasons. One of the main causes is simply that modern game music is going for the tone-setting Hollywood style. There's a ton of brass and horns, but none of it forms a catchy melody. There's also the fact that it doesn't play as loudly as it used to. Once upon a time the only audio for a game WAS the music (coupled with a few sound effects), whereas now there's dialogue that is essential to the experience, story and even knowing what your objective is. As a result the volume is reduced so you don't hear it as much.
Still, it's not just the old JRPG's that had some noteworthy stuff (also, Uematsu hit the top of his game with FF6. Let's face it, the main theme + the opera + the battle music + Dancing Mad + bits of other good stuff like the Phantom Train = just another reason it's the best in the series). Sure, I'll always remember EarthBound's final boss music [http://www.youtube.com/watch?v=ANhKF_pOv6Y], which was a fitting twist of sound considering the sudden seriousness of the final stage (y'know, having to remove your brains from your bodies and effectively go on a suicide mission...that somehow turned out to not be one).
I will always remember stuff like the old Mega Man tunes alive [http://www.youtube.com/watch?v=uYUsyLC6dOk].
If music could sound like that again, I'd be a happy piggy.