This is probably the best modern writeup on decoupling capacitance that I've seen. It's clear and brings the receipts!
My EE colleagues at Oxide (who are much better at this than I am) have been trying to drive this point into my head for years.
In related news, I just last week made my first board that was unstable at full CPU speed until I swapped out the 100nF "habit cap" for a 1u. It's real!