I really enjoyed it for the first couple of weeks I had it, although I was already frustrated by some of the design choices (namely clan functionality and grimoire access being restricted to companion apps/websites).
However, once I beat the main game and got a few extra levels with the light equipment, I fell off the game pretty quickly. I don't have enough friends playing to tackle the raid, and while I'm sure I can find some people on GAF, I always find it a bit awkward playing this type of content with people I don't know well. Some like to take dungeons casually, others want to get through it quickly; it just ends up being more work than I want to put in to team up with like-minded participants.
It's really a bummer, since I love the action in the game, and the shooting is absolutely top-notch. However, the implementation of MMO-like grinding and missions, without the easy access to communication normally found in an MMO puts the game at odds with itself. There's so much potential here, but this iteration of the Destiny universe has not left a great impression. While I'll most likely check out the DLC since I bought the Season Pass edition, I don't think I'll spend much time outside the new missions.