I've had a mac for about a month now. I used OOo on windows for years before that. When I came to mac my friend suggested to OOo 3.0 aqua beta. It's really nice. It looks beautiful, has all the features I'm used to, and uses all the default Aqua windows.
However, its not the stablest application. I've had issues with importing Office files that include formulas, and printing Impress documents in a manner other than one slide per page is a chore. It also crashes more often than I like (however, I've never lost a document or work... its got good recovery).
I got NeoOffice 2.2.3 yesterday and used it for most of the day. The icons are ugly as sin, but functionally its extremely similar to OOo. I find that NeoOffice is slower to open than OOo, but once I'm in files it works much faster. It also (most importantly) fixed the few bugs I mentioned above.
So, my final recommendation as someone who has used both - get the OOo 3.0 aqua to see if it will work for you. Both my bugs were rather specialized, for general stuff it worked fine. It never crashed while I was doing something simple like just typing a document, only with more advanced use. If its still too alpha-ish for you or if you don't want to mess around with it, get NeoOffice.
In either case, I wouldn't recommend OOo 2.4 for mac.