So is Destiny 2 any good as a single-player experience?
Great. I played most of it solo-style.
Should take you anywhere from 8-20 hours per playthrough. Depends on how much of main stuff and especially side stuff that you do. This is what the game's great at, IMHO.
Also game-time length depends on if you have any interest in the Crucible PvP, which I think is lacking. Everybody seems to be level 20 cap (from base-game owned only) or level 25 cap (i.e. 25 is max w/ Osirus DLC) - so, doing this early isn't a good idea at all. You just won't have a chance w/ low-level characters and especially w/ low-level gear. At level 18, still got pounded. So, I threw the towel in on the PvP, for now.
When you do most main missions here, they're alone missions/instances; especially often for the first time you actually head to a new planet. That often starts w/ new solo instance/mission to introduce you to the entire planet (or a fair deal of it).
I think the missions, combat, gunplay, loot-craze addiction, technical performance, and graphics are all fantastic. Story and character stuff is nothing special (but would you expect that in a game like this?) - but all of the other stuff related to gameplay and gunplay is something special TBH.
When the game tosses you onto the open-world part/hub combat areas where you run around, do mostly side missions, and do some solo missions - you'll be on with other players. In some ways, it felt like a mini-instances of The Secret World - players are in the middle of missions or just killing monsters for loot and XP, so they might help you out for a second and then go off to go back doing their own thing. I experienced that a lot on Destiny 2 PC.
On servers when in the open-world part/hub combat areas, there are public events. Game tells you when and where it'll arrive. So, it's pretty cool when players all pour in, waiting for a few moments for this big event to go down. It's cool to see say a big ship arrive and enemies pour out or a big machine boss fight happen, as the rest of the players on the server come in to help out and take down the public event. It's a lot of fun and reminds me of Guild War 2's public events that are boss fights.
Also, if you are looking to meet-up w/ players - you can use Friends function in-game or go to The Farm area (or the new area after you finish the main-story) to find more players. I didn't really utilize that stuff for the most part, TBH.