Is it true that those who can most afford it will pay the most for the CPA?

Yes, CPA puts a surcharge on local property tax bills, homes with higher assessed values will have higher property tax bills, and thus will pay a larger CPA surcharge.  The exemptions for moderate-income senior homeowners and low-income homeowners assure that those who can least afford to pay the CPA surcharge do not have to pay.