If I hold the rear brake and really stand on the cranks, I can flex our tandem. But when the two of us are pedalling, there's no flex, and we have some pretty snappy performance. For road bikes, I prefer steel, no question. But if you've got the money for a quality titanium frame, they're certainly worth it.
Don't knock another man's frame until you've ridden it a while.