It's really not unintuitive. It's just like nested for loops. It's just like recursion. The most nested item always completes first.

Nested BEGIN blocks and use statements are only executed in reverse order if you look at the start of the statement. They're executed in-order if you look at the whole statement or the end of the statement. How can you execute something before it's compiled?