Didn't he save Twitter from total bankruptcy? That's effective imo. Still SpaceX and Tesla are examples of effectiveness overall.
He may not have been effective in all his ventures but for the majority he has been effective.
I'd say going into space and creating an effective electric car product is more than optics.