There’s some story but not much. It’s much more sandbox than narrative. The story is mostly background for the sandbox. There are a few Community Expeditions each year that are additional guided tasks. The rewards are mostly sandbox stuff.
If you’re content with mission type activity—gather these resources; find these things; reach this milestone—then it might be worth the price, especially on sale. It’s cheap anyway.
I’d guess it’s not for you. Maybe, play a friend’s copy?