@Polkadotties
One thing to note, APCs do not provide spouse’s or child’s pensions so if you die so does the APC
Good point. An an odd one, too, considering that the Teachers Pension Scheme and the NHS Pension Scheme, which are in many respect similar, do give you the option of buying additional pension with or without spouse benefits.
Another important point is that all these schemes (TPS, LGPS, NHS) are unfunded schemes. What this means is that the money you and your employer pay in go to the Treasury, which uses them as if they were tax revenue, and the money that must be paid out comes from the Treasury, too, out of the government budget and general taxation.
This is different from defined-contribution schemes, where you put in some money, you invest it, then your pension is whatever that pot of money has grown into.
Also note that not all defined-benefit schemes are unfunded - e.g. the University SuperAnnuation Scheme is funded, meaning the contributions are invested and pensions must be paid out from that pot.
Whether you think an unfunded scheme is good or bad depends in great part on your views on the country and its stability: in an unstable country it's not a good thing because the currency may plummet (whereas with a defined-contribution scheme you can decide to hold investments in EUR or USD), the country may go bankrupt, the government may have to cut pensions, etc.
In a stable, Western democracy, most people (but not all!) would argue that these risks are low and that are far outweighed by the advantage of having the certainty of a fixed, inflation-linked pension.