[indoorskier]

I have an MSc in CS so biased, but I think on balance it's worth it, if only because you'll be confronted with subjects outside your comfort zone. Even if you don't "like" them they'll broaden your perspective, and who knows you may learn about something you wouldn't have heard of before, and really interests you.

Definitely depends on the curriculum though - my advice would be to look for timeless subjects, so "Algorithms and Data Structures" over "Game Programming with Unity", with a lot of variety.

This is all from the perspective of you being interested in learning new stuff regardless of monetary gain. If you're thinking of this more transactionally, i.e. "will I be able to get more money/better paying job" then I think it depends a lot on where you live. In some areas formal education is valued more than in others. Also a good part of it will probably not be immediately applicable to the day job - at least not obviously so - but it should give you a decent perspective on the field as a whole.