Nielsen Norman Group’s Top 10 Application-Design Mistakes is a good reminder of common pitfalls when creating complex applications. This is recommended reading for everyone (not just designers) working on these sorts of applications. As they point out, it’s challenging to get this right.
This one is going on the UX Bookshelf.