Since I didn't really have any friends on PS4 who played Destiny I played though the original and taken king campaign by myself and enjoyed it, it wasn't life changing or anything but the shooting mechanics and loot kept me having fun and I spent hundreds of hours with Destiny before I parked it.
I agree with Frank that Destiny SP pales in comparison with MP co-op campaign and raids, but it was enjoyable enough for me to spend hundreds of hours on it and to pick up a copy of the legendary edition on XB1 when it was on sale this Christmas, where most of my console friends are. So I have a copy there and the new DLC to play through yet
Looking forward to Destiny 2 but will be switching to PC this time for maximum co-op capability with friends.