Now what i thought was that it might be used to connect 2 computers with each other so i tried that and connected 2 computers with each other using it and nothing happened
Can anyone tell me what this cable is even used for ???
It's not an officially sanctioned application of USB, but some product vendors use it for various reasons. After all, a USB cable is just a bunch of wires (some twisted together a special way).
One example that springs to mind is the HTC Vive link box. This was made before USBC was very popular, and I'm guessing they wanted USB 3 speeds with a lower profile connector. Typically, you'd use an A to B cable, but the B connector is much taller.
Generally no - USB connections are asymmetric, with hosts and devices. Your PCs are both hosts - they cannot function as devices or communicate with other hosts.
Nope. Computer USB A ports are "upstream ports." Both computers would be expecting to find a downstream device on the port. USB needs a single host to control everything. Can't have two hosts.
If it was already tried with this specific cable and it didn't work, then this cable doesn't have the capability built in. Some cables like this have a bridge in the cable that allows pc to pc communication.
Not without special support from the hardware and software. But a smartphone is pretty much a PC with specialized hardware and software. And you can certainly plug your smartphone into a PC to share photo's.