While I've not tried LibreOffice (downloading now!), I think the Camino / Firefox comparison is a good one. My reason for choosing NeoOffice was because I wanted the most Mac-like experience and without a dependency on Java.

It looks like the main difference/advantage right now is integration with the native Mac font rendering & grammar/spellcheck engines, according to the front page of the NeoOffice website.