Since we're sharing our experience with the game, I'll add my 2 cents.
I've enjoyed big parts of the story, especially post HW and many other aspects of the game, but the endgame part for midcore players who are not interested in raiding never did it for me.
Yes, new dungeons added with each patch are cool the first 1-3 times when you go through them, but after that they become a 20+ minute slog of running in a straight line, killing packs of enemies which don't drop anything worthwhile/don't give xp etc. There's almost 0 chance that you will die outside of bosses, unless tank/healer is really bad. I hate having my time wasted, so I usually stopped my subscription shortly after getting through the content.
I'd usually go back when a new patch hit, finish new MSQ, new trial HM, new dungeons, grind for 2-3 days and get bored. Luckily this changed with the addition, or rather the expansion of the Palace of the Dead dungeon. While nothing groundbreaking, this random dungeon is a great way to get exp, tomes, gil, a decent weapon, and get used to playing with new classes.
While the first part, floors 1-50 aren't that great, I ran through 51-100 multiple times and usually had a blast, be it with friends or randoms.
The best part was definitely trying to solo floors 1-100 without dying for the achievement. In the end I got to 132 with a Warrior, a class that I barely play (my "real" WAR is on level ~30).
Long story short, give PotD a go if you haven't and if you have a break between levels where you'd have to grind dungeons/fates for exp, do PotD instead!
My other complaint is about the exploration. WoW, FFXI had the sense of wonder and danger where you got into new areas. While some of it might be nostalgia speaking, FFXIV ARR areas felt super cramped, especially with both high and low level zones on the same maps. HW was better in that regard, but the changed was from "too small" to "big and empty", so I can't say I'm a huge fan of that as well. I really hope they will strike a good balance in Stormblood.