Marco does a good job explaining the context of checkpoints and their relation to things like assumevalid. Checkout from this timestamp:

https://bitcoinops.org/en/podcast/2025/03/25/#bitcoin-core-31649