I paid out of pocket and it has financially been worth it. A lot of companies will pay for it, but I wasn't in that position. If a company pays for it they might want you to agree to work for them several years after you finish.
If you don't love learning and being in school, it's going to be a long unenjoyable slog. If you're only doing it for money or vanity, that may not be enough to carry you through the hundreds to thousands of hours of study and homework you will have to do.
You will encounter a lot of naysayers, as you have already seen in this thread. This includes family and friends.
You will also get better advice in a different forum. A sub reddit dedicated to your industry for instance?