I enjoyed Endwalker. Is it perfect? No. There are areas in the story I felt could be improved, but no expansion or game is perfect. Plus when it comes to lore much of it is subjective. My personal ranking goes Shadowbringer, Endwalker, Stormblood, Heavensward and ARR. Enjoyed them all though.