Anything that's long, visually dull, and lacking save points (in a game that has them). I remember the Omega Ruins in FFX being quite annoying to start with. Although that decreased when you overpowered the hell out of your party.
It was infinitely nicer on the 3DS remake.