Bibus is a fully featured bibliographic application, that can integrate with OpenOffice.org. It's available as a deb installation file, which makes installation much easier than in the past. I use it on my Linux PCs, but it's also available for Windows, and can be used with Word.

I can only think of Pros (no Cons). It integrates really nicely with wordprocessors, and bibliography fomatting is very flexible. You can choose one of two databases - MySQL or SQLite. I've only ever used the latter.