I used it for quite a while on my Mac Mini but ended up splashing out in the end for Office 2011 Home & Student (which allows me to install it on 3 Macs).
Why? OO was 'fine', cant think of anything bad to say about it really but it just 'wasn't Office'. They've done a real nice job on 2011 for the Mac so I just personally found it a lot nicer to use than OO and i'm a lot less likely to run into any compatibility issues when sharing docs (had a few with OO, nothing major though as i'm not a heavy Office user, just some layouts of docs sent by other people going to cock).
One thing i messed up on though is buying the cheap Home & Student edition. I got that then realised that I really should have got the version with Outlook in it as am not a fan of any of the Mac email clients. I'd assumed there would be an upgrade route where I could add-on Outlook, or buy it standalone, but no, i'd have to buy a new copy of 2011 Home & Business. So if you're getting it, i'd recommend getting the Business edition straight off. Not tried it, but reading around, looks like Outlook 2011 Mac is decent.
Plus, if you are using Lion, MS are apparently working on an update to 2011 to add integration with Lion's auto save, versioning and full screen mode.