I've been to the WB, Sony, Paramount, and Universal tours (and Disney, but as mentioned it is not generally open to the public)
In my opinion, WB is the best one overall, but as someone above pointed out, it may be because of the shows I'm interested in. I just think it's the best run one and most organized.
Second would be Paramount, their studio has a lot of history inside of it.
Third would be Sony, the last time I was on there it was kind of disorganized, but that may be because they just restarted the tours after covid. Even taking that into account, it's probably the least interesting.
Fourth would be Universal, just because you stay in the tram the entire time. It doesn't come close to what you would see on the other 3 tours.
Note that Sony is an all walking tour, there is no tram or cart.
WB you go from place to place in a cart, and get out multiple times
Paramount is also on a cart, and get out multiple times.
Universal is obviously all on the long tram.
Now, if instead of the regular tours, you are talking about the VIP tours, my order changes:
VIP tours:
First would still be Warner Bros tour, it's just very detailed and organized and interesting. (note that they call it the "Deluxe tour")
Second would be Universal, it is improved greatly from the standard one and they have lots of great information on this version of their tour.
Third would be Paramount.
Note that the VIP tours from WB, Paramount and Universal are very close in my mind, so even though Paramount is listed third, it's still very good and much better than the starndard tours.
I never took Sony VIP tour.
The order for the VIP tours is mainly because of what I am interested in.
As far as tram or cart, the only big difference is Universal, in which the huge tram you are on, is instead a much smaller VIP trolley, and you get on and off multiple times. I believe the Sony VIP tour you are on a cart at least part of the time, but I don't have personal experience.
Note that on the VIP tours, you get some food, and generally the food is a nice table service meal. Universal has an all you can eat buffet, which is by far the best food at Universal.