The 24-290 is a beautiful lens.
The out of focus highlights wide-open look really glamorous. They are perfectly round and look great. That extra 40mm that brings it to 290 seems to make a big difference.
As a focus puller, of course I hate any lens that the DP can suddenly crash in to 290mm without notice :( but the Optimo has a special charm.
Sure it weighs a ton, but once it's mounted, it can often stay there for several shots.
Clairmont Camera has modified their Optimos to include a nice contoured handle right at the center of balance of the lens. Since it's Clairmont, they have also added a threaded hole to the handle so you can mount your onboard monitor right there within your field of view. If you're shooting at 290 mil at 2.8, you might as well see what the DP is aiming at!
That extra handle came in very handy when Harris Savides and Dante decided to use the lens as a director's finder and lug it all around downtown Toronto last year.
In my experience, the Optimo looks just as sharp as the Cooke S4's, but is slightly more prone to flares, just like any zoom lens. It cuts perfectly with the S4 look.
The optical voodoo mentioned above about zooms having less depth of field than primes is completely true. Macro lenses take it even a step further.