Yeah, this all gets pretty simple. The tonal difference among cables is due to capacitance, and really only impacts passive instruments (once you put a preamp in the circuit, the capacitance differences greatly reduce).
All other things being equal, the longer the cable, the more capacitance, so cable length can have an impact (again, primarily if you don't have an onboard preamp). It is why many guitarists are fanatic about short cable lengths, since most guitars are passive, and of course, they have a LOT of upper frequencies versus bass guitar, where all this is not quite as much an issue.
The impact of capacitance strictly impacts the upper treble response. No cable can have more low end than another cable, but some cables do sound more 'full' because the higher capacitance of some cables reduces treble, resulting in the ear hearing 'more bass' (i.e., a psycho-acoustic phenomenon).
The best way to experience this, IMO, is to take the two 'capacitance extremes' of cables..... the George L's (EXTREMELY low capacitance), and the Monster Bass cables (EXTREMELY high capacitance). Make sure the cables are of the same length.
If you are using a 'full range' instrument with relatively new roundwound strings (i.e., where your signal source actually puts treble into the signal chain), you will hear the George L's sound 'brighter', and seemingly having a touch less low end (they don't), and the Monster bass sounding dull up top and seemingly having a touch more low end.
Even these two extreme cables result in a relatively subtle difference that mostly goes away once you kick a preamp in on an active bass.
Most other cables are within a capacitance range to sound literally identical to each other.
IMO and a lot of IME on this one. Bongomania has some great threads, tests, etc. on this topic if you do a search.