Destiny 2?
It’s got a few smaller campaigns built in with the expansion packs. They’re all on Xbox game pass currently. Not sure if they are on the PlayStation equivalent.
It’s a bit of a ‘grind for the best gear’ game, but you don’t have to do that to enjoy the game. I’ve happily spent a fair few hours on there just shooting stuff.