I found NandGame[1] to really help illustrate just how a simple CPU operates. The bottom-up approach was great at demystifying the various sub-units and how they come together to form a CPU.

Of course, modern CPUs are incredibly more complex, but most appear to function like a really fast, simple CPU.

[1]: https://www.nandgame.com/