USB Power Only - Detect Device Plugged In
USB wasn't designed the way you want. The connect event is simple: host keeps VBUS on; if deice is plugged in ("attached"), it senses the VBUS and asserts pull up on one of data lines. This is the "connect".

The detection of "attach" is always challenging. In some later USB development (particularly with advent of "battery charging"), there were proposals of special 5-pin USB connectors with additional "sensor contact" pin, see this FCI drawings. 



But this is all gone, history. 

USB 3.0 detects the attachment by sending short pulses into Rx wires, and measuring resulting RC, the circuit is built into transmitter. 

You can try to detect the extra massive ground/vbus by doing something similar (RF pulses), but again, it is splitting hairs and can't cover all variety of cables.

In short, in 25 years of USB development, engineers haven't invented a cheap and reliable method to detect attached cable without powering it up, or having extra contacts in connector.