Stingrays and Sterlings will usually go for $750 to $1K used. I picked up and SR5 3 weeks ago for $850. $#!tty case and horrendous pickguard though, so I'm out another $35 for a PG and $65 for a case. That being said, the SR5 diplaced my MTD Grendel (original production run with wenge head stock, serial #14, yes, 14) and my 1986 P-bass at the top of the food chain. For Rock, there simply is no better bass. You may find some others that are as good, but none better. As far as funk, Stingrays and Sterlings were created for funk.
Stingrays are not light. They are not going to break your back (10.5 lbs), but they are virtually all made of ash. If you are used to playing a bass made our of basswood, it will take you a couple of weeks to get used to the weight. They have maple fingerboards. Mine does, and personally I think that maple best compliments the intrinsic tone of a Stingray.
All of this info applies to Sterling, except the weight. They are a little lighter. The tones are very similar between the two, although the Sterling a coil tap feature and hot-rodded Pup setting. These features are also found on the StingRay 5, but not the 4 as far as I know.
You will lover either one.