I expect two FTTP providers to cover my address by the end of this year - Jurassic Fibre who use CGNAT(no IPv6 currently) and Openreach who use PPPoE(AFAIK). What are the pros and cons of CGNAT vs PPPoE? Is it worth going for Openreach to avoid CGNAT?
To a degree it depends what you use your connection for.
CGNAT (especially without IPv6) is problematic for several reasons. Firstly, it's hard to do any sort of inbound port forwarding to servers on your own network. Secondly, you could be falsely accused if you are sharing an IP address with someone else who is misbehaving.
On the other hand, there are no real "cons" to PPPoE: it's the standard way of delivering broadband and it works well. You may want to enable "baby jumbo" frames to get full MTU 1500. That's it really.
Some badly-implemented routers perform poorly with PPPoE at gigabit speeds: hence either use the ISP-supplied router, or choose your device carefully. If your connection is 300M or less then this is very unlikely to have any effect at all.
Finally, note that Openreach don't "use PPPoE". It's the ISP which runs over Openreach which may or may not use PPPoE. For example, if you buy Talktalk or Sky FTTP via Openreach, then you will be using IPoE not PPPoE. Openreach just passes the ISP's ethernet frames through transparently.