Base Heavensward, Post Stormblood and Shadowbringers had the most impact to me, particularly the latter.

To see even the main protagonist (WoL) being vulnerable & comes close to breaking or dying; that kind of stories always stirs me emotionally, in a bizarre way. (I do not count those active time maneuvers moments in duties, btw!)