Ah I've been really wanting to give that a shot but unsurprisingly am far more of a single-player story guy, especially now with life commitments. The only time I tried online gaming was Destiny when it was first released, off the back of Bungie's fantastic storytelling in Halo, but just didn't have the time to commit properly to those bloody pain-in-the-backside raids. That and nobody I know shares my gaming predilections. So with that in mind, would you recommend it being worth me giving FFXIV a shot or should I just forgeddabbouuddeeett?
I did, because FF fans wouldn't shut the f up about it, expansion after expansion and I really couldn't ignore the noise any longer. Transitioning from 1.0 to ARR with a world-changing event accompanied by an unforgettable CG cutscene helped reel me in like a little fish (owning and transforming a bad launch into a story event is an incredible idea). The FF XVI hype and knowing they shared much of the main talent was the final (fantasy) nail in the coffin.
I have the whole thing up until Shadowbringers and I'm halfway through Stormblood, the second expansion. Knowing we're more or less at the same point in our lives, it's kinda hard to recommend in the sense that it's a massive timesink and not all of it is great or exceptional. I myself dropped the game after the main ARR quest because the patch content really tries your patience - and that's just doing the strictly essential main story quests. I got back to it months later (now) and it's much better. The flow of things is - main quest, patch with quests that set up the next expansion, expansion, patch and so on and so forth.
With all that said: for reference and like you, I don't do online gaming and I stay (.... ed) away from MMORPGs like the plague. I had a few freak accidents where I got hooked on Bioshock 2 MP for a while, Killzone 2 as well but that's that.
Like many say, and I simply echo: FF XIV is very single player friendly and you can play most of it on your own. Fights against primals, dungeons and raids are the exception but again, the game pairs you up with randoms easily. Get on a waiting list and in you go. The A Realm Reborn main quest is good and a treat if you're a FF fan, they do a good job integrating series history and it's very gratifying.
The subsequent patch is extremely long and quite honestly a bore for long stretches, but it does have my favorite moment in the series so far - a fight against a primal (XIV lingo for summons).
Heavensward is great, with an interesting conflict, great characters (a strong point of the entire experience) and if it's true the game has no reservations about throwing a ridiculous fetch-quest right after an important story beat, it's also true that when it gets going, it goes all the way. The translation and voice acting are stunningly good and a pleasure to read and listen to. The final battle is the kind of stuff where they take a fan favourite thing and integrate it in a really hype way.
The raid they added with Heavensward is, again, a singular treat for fans - they took Alexander, the summon, and made a set of short raids (I look at it as a dungeon, even if they're split up) with a ton of bosses inside it, and tied it all up with a great little story. They even put super sentai references in there, it's so good. It's the only non-mandatory content I completed, but I enjoyed it.
As for Stormblood, I'm enjoying it. The antagonist is interesting in how evil he seemingly is, but what continues to push me through the whole thing is the promise of excellence in Shadowbringers and how Endwalker is supposedly an excellent conclusion 10 years of story and characters - it's true I want to see where the characters end up and what they do. I'm certainly invested in this group of people.
The music is great. You'll find an incredible track where you least expect it, like a new field theme or a new battle or boss theme.
And finally, the community. From my experience, people are uniformly excellent: nice, patient and helpful. It certainly helps.