I do actually have a set of two-spokes so let me try to answer. They were part of a sponsordeal, I got them for free so needless to say my answer will be extremely biased.
I race for The Netherlands, it is one of the poorest countries in the world so even our top athletes can't afford Zipp wheels. For me the two-spoke was a huge upgrade after the wooden wheels I was used to. There are pictures of me on the internet, suggesting I formerly rode Xentis, 808/808 and 808/disc. Don't believe everything you see on the internet.
Dutch engineering can't be trusted either. We built a country below sea level. That is just impossible. The two-spoke is a hoax, they will break into a million pieces over the first pothole. Yes we did send our national tandem to Rio on two-spokes, but everybody knows there's two riders on a tandem so the stress on the wheel is only half, right? That is just cheating. And the tandem came second, so they lost. Olympic silver is no good.
Sarcasm aside, nearly all current national champions for The Netherlands, in all UCI and ITU categories now ride the two-spoke, be it elite without contract (Remco Grasman), UCI masters (that would be me), handbike (Jetze Plat) or Triathlon (Bas Diederen). The odd one out is elite with contract Tom Dumoulin, as he's tied to an existing sponsor contract (and you can't really repaint/resticker these wheels, it will show).
So Tom doesn't have a choice, but I do. Guess what I am racing with this season.
As for looks, that is a personal matter. I think they look hot but if you think they're fugly that's fine by me. I just like to be faster than you, not prettier.
Here is my 2017 bike, looking smug at Club La Santa (I should have removed the saddlebag for the foto). My friends call it the batbike. Mind you, this is a fully UCI-legal TT bike.
PM me if you're serious and want to test ride the two-spokes, as that can be arranged. I live near Club La Santa (Canarias), a very nice destination for your next training camp. In a field test, your powermeter and GPS will tell you all you need to know. What you will also find out in a test are those little things. How these wheels have a ceramic lining on the rim that gives your brakes a real "bite". My Shiv-TT used to be downright scary in the descents on all other carbon clinchers, now I can brake into hairpins with confidence. Those are free seconds in every corner. They also make the nicest propeller sound at speed. Something to listen to and keep you in the zone.
Happy TimeTrials, Pieter Aben