fierytempest got it in one for me - the mountains seperating Rocket Town and Nibelheim are nothing short of a dungeon that goes on just a little too long and on my first attempt it took a bit of figuring out just to get through it.
Another moment is just after Meteor appears in the sky, but before the Highwind is obtained. Because during that time the music on the world map is a real downer. Sure, it suits the atmosphere, but I still don't like it.
What are you? Dead inside?Red XIII is an awesome character and to give him his moment - just as every other character (let's face it, all but three of them could be classed as having "little to no importance to the overall plot") has their moment, too. Also, Red's little subplot is the most touching of them all. The most moving moment in any video game can not be considered boring, surely?
The parts that I don't like to do with Cosmo Canyon are all the parts that aren't required to follow the small subplot. In other words, the long talks with Bugenhagen about the planet, the various bits surrounding the fireplace. The bits telling about Red's parents and obviously the inevitable discovery of the truth about them? That's something that should be considered unmissable.
Still, it would be even better if it wasn't for Red XIII going from intelligent, mature, scarfaced beast to little baby grandpa grandpa help me waaaah cub afterwards. A character so cool should still be able to keep his head after such things, especially after he's been likely tortured at the hands of Hojo for some time.