Is a CD ladder pretty much the default way to go for this, or is there anything better?
If anyone were to answer this question without you asking a bunch of questions first is doing you a great disservice.
Here are some factors:
1- how old are you? 2- what are your current debt situation? 3- what are your current investments? 4- what is your current income? 5- what is your current liabilities? 6- when do you plan to use this money? 7- is the 800k in some sort of inherited retirement plan like a ira or roth ira? 8- what is your current marginal tax bracket?
Etc, etc...
You'd be surprised how big of a mistake you can make here by doing the wrong thing.
CD ladder isn't a bad choice. A treasury bill ladder could also work and might actually fit as well. The risk is in a rising interest rate environment the t-bills you buy now will be worth less in the future. You'll still get the dollars in absolute terms but it might buy less. Too bad you can't buy I-bonds past 10k a year.
Also the biggest risk in your plan is the "leave alone and not manage". There is manage a little, manage a lot, or pay someone to manage it for me. Leaving it alone and not managing it has its own risks.