I fully agree about the importance of music in gaming, or in any audiovisual medium for that matter. It's definitely a key element to set the mood of the game, highlight its events, or convey whatever message or emotion you want to communicate. It's one of the things that makes a game unforgettable to me instead of just good.
As you mentioned, Mega Man X is a great example of this. Even with its rather simple story and character development, the game manages to get you into its universe and events in big part because of its memorable music. It's how the game motivates you to overcome its obstacles. For example, the moment when Zero shows up to save X at the end of the opening stage against Vile and how X talks about his shortcomings wouldn't be as significant as it is to me with another OST. I can't think about that moment without these two wonderful themes coming back to me:
http://www.youtube.com/watch?v=TdAVDNYhJuk
http://www.youtube.com/watch?v=U3jhUQHGpuQ
I should also note here that I'm a weird case when it comes to music, as most of what I listen to comes from either videogames or anime...
Now, as far as graphics goes, I've never cared much about the technical side of it, but the "artistic" or "creative" side is quite important to me. Just like how I can't think of Chrono Trigger, Mega Man X or Street Fighter II without its music coming to mind, I can't forget about their wonderful art and pixel work either. Or the visual design of Ocarina of Time, even with its now dated 3D graphics. Or the beautiful anime-esque cutscenes that Tecmo managed to craft on that old 8-bit console, like this one:
http://www.youtube.com/watch?v=xN_r51d-oL0 (still one of the best openings in gaming to me, as well as one of the best endings... "Tecmo Theatre" indeed...)
If your comparison includes this facet of graphics and is not just refering to the technical side, I can't really say which one is more important... Both of them are vital aspects to me, regardless of whether you're trying to tell a story or not. However, I do agree that music is somewhat "underrated" compared to graphics these days... This is most evident to me when some people talk about how they regularly play games without music or with a custom soundtrack option, or how publishers invest money into getting some random popular music into the game instead of creating a soundtrack for it... But well, to each his own...
On a related note, all this is one of the reasons why I care little about what David Cage says on the matter. While technological advances do give us more and better tools to communicate our ideas, it doesn't make said concepts better by itself. Just like with movies or music, the core of the medium lies on the imagination and skill of its creators. The human talent behind it all. And when it comes to gaming, many developers have managed to evoke all sorts of emotions from me ever since I started playing games in the NES era, without the need of realistic graphics, HD resolution or 7.1 surround sound.
But I digress...