Here's an interesting survey from TIAA-CREF. Basically, faculty are very satisfied with their jobs, though they'd like more money (no surprise), and they (X-Gen in particular) wish they didn't have so many administrative responsibilities. Sounds similar to some of our JBU conversations.
http://www.insidehighered.com/news/2007/11/01/faculty