I wouldn't look for COBOL gigs in SV. I would look in places where keeping up with the technological Joneses isn't part of the culture.
I live in New Jersey. NJ and NY has a considerable amount of COBOL deployed, in banking, insurance, payroll, etc., and especially by government organizations.
Compensation is still on the lower end, like $90k-120k/year, vs. $160k-200k for more modern tech jobs, but the competition for those jobs is almost certainly to be lower/less competitive, you're less likely to be laid off if you're even remotely competent and don't do something stupid like break the law.
To OP's original point, if you're looking for a non-management role and want to maximize your earning potential while simultaneously minimizing your employment churn risk, being a competent COBOL programmer earning $90-120k/year comfortably definitely fits the bill.
Of course, if OP's statement that they are "sick [...] of doing the same CRUD apps over and over again" then COBOL may not be a good fit: you certainly aren't going to be doing much in the way of innovating when supporting a legacy COBOL application, but you should be able to carve out a very consistent work schedule, find some decent work-life balance, and enjoy perpetual employment as long as you desire it.