It took me just over 60 hours to complete all of the single player content with a smattering of PvE(vP) required to progress through everything. This includes all the expansions.
I have to say, I very much enjoyed the original campaign, as well as all the cutscenes which were incredibly juicy... and frequent. I really appreciated that I didn't have to grind at all to complete the story quests, and because of that I've very much been encouraged to continue playing the game as I'm now interested in just seeing what comes next. The gun play for this game is satisfying, and there's a large enough selection of weapons to make even the pickiest player happy.

This game definitely has enough content for people who enjoy grinding. The loot doesn't have Borderlands (or Warframe) level of variation, but it's a large enough selection, and the game encourages you to keep rotating your loadouts for different missions to get improved gear; which I think is a very smart choice by the developers as it keeps things fresh for the individual and keeps them out of a 'one size fits all' kit. I've applied an additional 50 hours of grind gameplay, with a decent chunk of PvP in that. While I'll never enjoy the competitive side as much as CS:GO or the new Valorant, competitive has a very punchy and high octane style like CoD which is fun and satisfying play. However, for me, this game really shines in the PvE with friends and completing challenging missions together.

As a free to play game, I think it's completely worth picking up and giving it a shot. Then, if you enjoy the game enough, you can look to purchase the expansions and a season pass as I did. What I was pleased to find is that even after 30-40 hours of game play into the base game, I didn't "miss out" on any of the loot or unique opportunities as most of that content is for late game anyways. If you enjoy FPS games in any capacity, this is definitely a game to at least play for the single player experience at the healthy price of nothing.

I do want to add a comparison in to Warframe as I've heard a number of people talk about it. I have 60 hours into Warframe personally, and I feel that is an acceptable time to give a fair comparison, especially to a casual player.
Warframe is a grind fest. Many die hard fans are going to try and play it off as being highly rewarding and extremely unique experience with far better customization and loot options than Destiny......... and in the basest terms, they are right. Yes, there is more Warframe content. Yes, the whole 'Warframe' concept is definitely unique and the options for customization are rather mind boggling.
But the game's execution is just... not as vibrant as Destiny's. Story progression is capped behind intense sessions of grinding to level up. Lore is honestly TOO hidden and requires a lot of time to read/find, which just doesn't interested me and is going to be a drag for anyone that's not a 100% completionist. The game is a series of repetitive missions which the only variation you have is your loadouts (which are numerous to be sure), which just doesn't cut it when its not as punchy and pleasing as Destiny 2.
Warframe is technically not pay to win, but unless you want to get 60 hours in and still not have any significant upgrades or changes to your gear... then you're going to be spending money on SOMETHING. To me, this game is honestly just... TOO grindy, for not enough satisfying return. Even having veteran guidance, as I had, it was still just taking too long to me. I shudder to think how much longer this will take for a new player on their own... and how much time they'll be spending on the wiki trying to figure out their next steps.
Now, this appeals to some. I'd like to bring up Path of Exile as an example, where the game does provide an infinite number of combinations for you to try out and play with; but it's just... not terribly satisfying to play when compared to Diablo, even if, technically, the content is far greater and time to complete is infinitely longer.

Take it how you will. To the people who enjoy the intensely detailed journey of Warframe (or PoE), they will always be the superior games to them, and they'll hate on this review. But for me, the far more vibrant experience that Destiny 2 (and Diablo) provide is far more important to me even if the game is shorter and filled with 'less content'.

It took me just over 60 hours to complete all of the single player content with a smattering of PvE(vP) required to progress through everything. This includes all the expansions. I have to say, I very much enjoyed the original campaign, as well as all the cutscenes which were incredibly juicy... and frequent. I really appreciated that I didn't have to grind at all to complete the story quests, and because of that I've very much been encouraged to continue playing the game as I'm now interested in just seeing what comes next. The gun play for this game is satisfying, and there's a large enough selection of weapons to make even the pickiest player happy. This game definitely has enough content for people who enjoy grinding. The loot doesn't have Borderlands (or Warframe) level of variation, but it's a large enough selection, and the game encourages you to keep rotating your loadouts for different missions to get improved gear; which I think is a very smart choice by the developers as it keeps things fresh for the individual and keeps them out of a 'one size fits all' kit. I've applied an additional 50 hours of grind gameplay, with a decent chunk of PvP in that. While I'll never enjoy the competitive side as much as CS:GO or the new Valorant, competitive has a very punchy and high octane style like CoD which is fun and satisfying play. However, for me, this game really shines in the PvE with friends and completing challenging missions together. As a free to play game, I think it's completely worth picking up and giving it a shot. Then, if you enjoy the game enough, you can look to purchase the expansions and a season pass as I did. What I was pleased to find is that even after 30-40 hours of game play into the base game, I didn't "miss out" on any of the loot or unique opportunities as most of that content is for late game anyways. If you enjoy FPS games in any capacity, this is definitely a game to at least play for the single player experience at the healthy price of nothing. I do want to add a comparison in to Warframe as I've heard a number of people talk about it. I have 60 hours into Warframe personally, and I feel that is an acceptable time to give a fair comparison, especially to a casual player. Warframe is a grind fest. Many die hard fans are going to try and play it off as being highly rewarding and extremely unique experience with far better customization and loot options than Destiny......... and in the basest terms, they are right. Yes, there is more Warframe content. Yes, the whole 'Warframe' concept is definitely unique and the options for customization are rather mind boggling. But the game's execution is just... not as vibrant as Destiny's. Story progression is capped behind intense sessions of grinding to level up. Lore is honestly TOO hidden and requires a lot of time to read/find, which just doesn't interested me and is going to be a drag for anyone that's not a 100% completionist. The game is a series of repetitive missions which the only variation you have is your loadouts (which are numerous to be sure), which just doesn't cut it when its not as punchy and pleasing as Destiny 2. Warframe is technically not pay to win, but unless you want to get 60 hours in and still not have any significant upgrades or changes to your gear... then you're going to be spending money on SOMETHING. To me, this game is honestly just... TOO grindy, for not enough satisfying return. Even having veteran guidance, as I had, it was still just taking too long to me. I shudder to think how much longer this will take for a new player on their own... and how much time they'll be spending on the wiki trying to figure out their next steps. Now, this appeals to some. I'd like to bring up Path of Exile as an example, where the game does provide an infinite number of combinations for you to try out and play with; but it's just... not terribly satisfying to play when compared to Diablo, even if, technically, the content is far greater and time to complete is infinitely longer. Take it how you will. To the people who enjoy the intensely detailed journey of Warframe (or PoE), they will always be the superior games to them, and they'll hate on this review. But for me, the far more vibrant experience that Destiny 2 (and Diablo) provide is far more important to me even if the game is shorter and filled with 'less content'.