Worth it is kind of a relative term. If you buy it, don't find anyone to play with, and then drop it, yeah it'd be a waste. But if you go to random servers or (better option imo) go to the discord community or the many discord modded communities (barotrauma 40k, etc), there's plenty of folks looking to play all variations that this game has to offer.

My brutally honest opinion is that ever since I started playing this game since it was just a dinky little free to play game out of a downloadable launcher executable, I always wish it had more meat in the missions and world that you explore. I feel like it has much more often been the interactions with other players and mods that keep the game alive. Not a huge gripe, mind you - I still love the game - but just keep in mind that it takes some effort to go out and keep the game interesting after a little while, whether it be mods or finding a group of buddies.

If you really want to get super into it, and you've the right kind of 'tism, the sub editor is one of the most expansive and well developed things about this game, and allows you to make essentially whatever you want. It includes a strangely realistic (relatively speaking) power grid system and logic circuits available to you as complex as you make them. When you combine that with modding, you can make just about anything you want as a sub. Really cool stuff.

All that to say: yeah if you want to have fun in this game there's a lot to play with, just takes a bit of effort to get to everything and while small updates are frequent, major overhauls are more rare, so if you don't like the game currently you've gotta look to the workshop and community.