A few thoughts based on recent experience.
I upgraded from a Weiss 205 with Fidelizer linear PSU to a Weiss DAC 501 Mk II, and it was a significant upgrade. Other DACs I have owned are the Chord DAVE/M Scaler, Nagra Tube DAC, Ayre QX5 Twenty, Mytek Manhattan II amongst others. They are all good DACs, but I rate the 501 Mk II more highly than any of these, based on my personal preferences. I do not agree with the comment above that it is too detail oriented and analytical. It is neutral and accurate without artificial warmth or bloom, but is full sounding, as well as being musical and engaging. I have not heard the Berkely so don't know how it would compare.
I have compared USB vs SPDIF and AES/EBU with the Weiss 501 Mk II a number of times, most recently in the last few days. I use a custom made PC based on a fanless NUC with linear PSU as a music server, and use its USB output either directly to the DAC, or to a Matrix X Spdif 3 and then SPDIF or AES/EBU into the DAC. The Matrix is also powered separately by a Fidelizer PSU.
The USB input of the Weiss 501 Mk II is very good. But it definitely sounds better through the SPDIF or AES/EBU inputs (depending on the cable) via the Matrix X Spdif 3, rather than using USB directly into the DAC. The sound is richer, fuller, slightly warmer, and slightly quieter.
Obviously, this is based on my specific configuration, and digital audio is very system dependent.
The ethernet input of the DAC is also excellent, but again the SPDIF and AES inputs are noticeably better in my system.
In other words, if you get the Weiss 501 Mk II - which you should certainly try to hear, because it is one of the best DACs currently available - you will need to experiment to see what input sounds best, because it is highly system (and cable) dependent. If you are using an external streamer, it will also depend on the streamer quality, including its own clock and internal PSU.

