Sam and I are going to begin work soon on a crumb-picking sort of literature review where information pulled from hundreds of observations will need to be meticulously organized. I use EndNote as a reference manager, and I've been pretty happy with it. If I could change one thing, I'd make it possible to color code references within a library.
Anyways, Sam said he's planning to use Zotero for this project. If you use Zotero I'd love to hear what you think of it.
I was also reading today about iWork, since I'll be getting a new computer before long and don't particularly want to deal with Office 2008. After reading reviews at of iWork, though, it sounds like I'm not in the target audience and so I'm probably stuck with Microsoft since I need the program to cooperate with reference managers and use things like equation editor and higher Excel functions.