Having a degree and a certification in the field can separate you from other n the field when you do not have a lot or as much experience as others/peers in the field.
Please take a look at the link below which is about Computer and Information Technology Occupations. It discuss several things that I think will be able to answer you question.
We all have our own preferences when it comes to the criteria of what defines "worth it", but I can share some of what I know:
- Opportunities: The sky is the limit when it comes to the types of jobs and industries you can land in. The majority of products these days have a software component, or at the very least, the majority of companies have an IT department where a software professional is needed. Additionally, with a CS degree, you don't always have to be a developer. You can also become a product manager, program or project manager, a data scientist, to name a few. So many things run on software, making the CS professional in very high demand.
- Pay: Software related jobs tend to pay high(er) in comparison to other corporate jobs like marketing, accounting and most types of engineering. I have heard that certain software jobs can pay as much as a physicians, if not more, depending on experience and profession.
- Cost: In comparison to a lot of high paying jobs, the financial cost to get a software degree or even a certificate is considered reasonable, so is the number of years needed for the education.
- Workloads & Flexibility: Depending on the role you have in software, long hours can be expected in-front of a computer screen, in comparison to a lot of other professions. This can be exhausting to a certain extent, but the beautiful thing about the software world is the amount of flexibility companies are offering these days. A large number of software companies have become fully remote, which means you can work from the comfort of your bedroom. This also means you no longer have to spend hours getting ready for work or commuting. To some this might be a pro, to others it might be a con due to missing the social factor, but what I know is that it definitely is a consideration.
- Entrepreneurship: Having a CS degree will enable to build your own (potentially monetizable) products at minimal to no cost or capital. A high number of billionaires and millionaires are folks with a software background that have started from zero.
If you enjoy math and solving complex and deep analytical problems, this might be a good route to discover. Take a beginners programming class, and take it from there. I hope this helps!