I just got a classic stingray. I own 2 P Basses and a 5 string Jazz. The Stingray sits in between those two in a way, it just matters how you play it. The treble knob is sensitive when you boost it past the middle, so if you keep it a little lower the bass will be very midrange forward. If you boost the treble it can get very bright and scoops the mids more.
The only way I can describe the classic ray is that it is a modern classic. It has the ability to sound more old school and midrange focused like old Sister Sledge records with the preamp more neutral, or like a modern fusion style bass with the preamp boosted a bit. It is quite responsive, which adds to the modern traits.
The best thing to ask yourself is if you like the defined sound of a bridge pickup. If the answer is yes, you will probably like a stringray. I should note that I tried all versions - regular, classic 4 and SR5 and the classic 4 to me was much different, in a good way.
Great post, the Stingray is a very versatile bass if you accept its basic parameters. I put a Dimension 5 on layaway for my birthday. It does not have Stingray highs, but it fills the same general frequency. I also a Squier Dimension 5, and it was a great bass too.
I posted a few clips. The first is a Mexican Dimension 5. Second is a Squier Dimension 5. Third is me playing Bernard Edwards style on a Stingeay classic. Fourth is me doing a slow version The Brothers Johnson Mista Cool.