Tim’s recent post SansBlogue: Referencing for the financially challenged generated a few comments, so he’s followed it up with SansBlogue: Zotero is brilliant, and integrates nicely which includes some movies of how Zotero works in practice.
I have Zotero installed on the old iBook and it’s integration with MS Word v.X for Mac is quite painless and seems to work well. Certainly I think it’d be useful for working on shorter documents (essays, articles and chapters) providing you were using a common citation style.
Of interest particularly to biblical scholars is Zotero Forums – Using Zotero with the Society of Biblical Literature (SBL) style. SBL with EndNote is supported (see here), though it is only for versions later than EndNote 9, I think.