TL;DR
The game is good, but you have to buy all of the DLCs for it to be good. The base game is pretty pointless, as well as the first DLC.
The game was bad at release, and became good over time with DLCs. The problem being, they're DLCs. You're paying a WHOLE lot of money, just to play a decent game. The game is good, but is it worth all the money you'd have to spend for it to be good? No. If you have a ton of spare money lying around, go for it. But if you don't constantly spend on games, I wouldn't recommend it. I wouldn't say it's a cult classic or a legendary game by any means(if people talk about the game being legendary, or a classic, or they can't say anything negative about it, I wouldn't go to them for advice on Destiny).