For the layman, accounting can appear to be boring, and working audit/tax for a small local firm is a pretty boring job, but your services will always be in demand if you are good with details, process, documentation, and Excel. No matter where you want to go, audit is usually the first stop, but you can quickly move into consulting which is far more interesting and demanding.
Paid well is a relative term. CPAs working for smaller, local firms focusing on audit don't make six figures, but work/life balance is better. If you want to get into consulting, work for a larger/large public firm, money is good, $150k+ before bonuses, but work can be 24/7 on some projects and it can be pretty cutthroat, but it's certainly not boring.
Another area is accounting tech and Saas. There are tons of platforms that offer SaaS accounting products that need real accountants to understand their products, and sing their praises in a sales role.
Point is, there is a broad spectrum of what being a CPA can do for you in a profession.
Personally, I studied finance, and am a CMA and FP&A because like
@Novahunter I wanted to understand the why and leverage that to help businesses better position themselves for the future.