Limsa Lominsa definitely had the best early mission cutscenes. >_> That was awesome.

That said, and I haven't gotten there yet myself due to charming mob placement w.r.t. the rank 34 mission (and not quite being high enough level), I've heard the last main story mission is pretty much a 'bring my brown pants' cutscene.