I found the Endwalker rolequests to be "meh". Except the melee DPS one in Limsa. That was fun!
I also liked the final duties of the melee DPS and tank rolequests. They felt at least somewhat challenging. They were also good narrative moments, with
that exhilarating rush in the melee quest to DPS down the adds in time, and that relief when the rest of the team hops in to rescue you. In the tank rolequest, the health of you and your comrades slowly whittling down felt tense, and then when that lancer guy at 5% HP left taunted the boss away as Kan-E-Senna was about to cast the spell, I thought he was going to sacrifice himself.
Sadly the other final duties of the other rolequstlines were a snooze.