It can be played almost entirely single player from the beginning now, and the story is really good after ARR (which is serviceable for setting up the world).
There is also a free trial that goes through Stormblood (the second expansion) so you can try without paying anything