Down sides/Cons to Dual-Sided USB connectors?
Do non-standard connectors suck compared to standard connectors?

Completely depends on the quality of the connector and how non-standard it is. Hack-y solutions result in hack-y results. Have fun trying to figure it out as no one really knows.