The website ArsTechinca has posted an in depth review of Leopard (a full 17 pages, in fact). The review takes a very deep look at the new features and the core technology. Of interest to designers is the effect Leopard will have on Adobe and future developments for 64-bit computing.
If you are a Mac user, take the time and give it a read. You'll learn a lot about some of the less obvious changes.