The demo (shipped as version 1.0) worked perfectly, except that any attempt to change the graphics options, bit depth, or resolution would lead to an OpenGL error. You were locked into 640x480, but the game was eminently playable...
The common shipped version of the game (like the one on GOG) which comes as 1.05 also works, but suffers from severe noclip errors in rendering textures. Using DirectX leads to crashes and white screens. Apparently it's due to a problem with z-buffer rendering, stemming from a bug in the game engine itself (details here: http://bugs.winehq.org/show_bug.cgi?id=11970)
The common fix is apparently to enter this into the console:
gap_iDepthBits=24
ApplyVideoMode()
But in my experience, it barely works; on the solo campaign's intro level, the game is still practically unplayable.
Other tips outlined earlier, like setting winecfg for Windows 2000, using a virtual desktop, etc. doesn't work. My test system is a GMA 950 Core Duo MacBook with CX 11.03 and OS X 10.6.8.