Sort of surprised nobody replied yet.
What you should consider is picking your DAC based on what you want it to do for you, then pick the interface connection and cable to accomplish that goal. As you noticed, some DACs have limitations associated with different interface types.
There are always higher quality connectors, but there's not much to be gained from them. Once a solid connection is made, or in the case of optical, a connection with strong optical transfer, there's no improving it. Connector quality comes into play if you plan to do a lot of connect/disconnect cycles, otherwise, not much of a factor. There are two common types of optical connector:
My experience is that the 1/8" mini version (left) can be a bit fragile, but even though I've had one break between the shaft and the handle, it still worked fine.
I know it's been debated, but since what you're doing is transferring data, once that's done in a way that transmits data error-free, there's no audible difference between cables. There may be certain performance advantages for a specific type of connection, but it's related to design of the DAC more than the cable or connector.
One last thought, again highly debated: there's little evidence to support an audible advantage of high sampling rates, especially over 96KHz. There is a similar lack of hard evidence to support that converting original CDs to high rate/high depth files does anything positive.
The one possible advantage to an optical connection to your PC is that it isolates the DAC electrically from the PC, and PCs have notoriously noisy power supplies. If the DAC is to feed an audio system, that can be a concern, and the isolation of a non-conductive data path is a very nice plus.