I have owned or still own many of the basses the OP and others are mentioning here and there really isn't a bad one in the bunch. Each has their own pros and cons depending on the type of music you play and your style of playing. Here's a quick rundown...
A used Spector Euro can easily be had for $1200 or under and will deliver a very authoritative deep growl, excellent for alternative rock, punk, metal and some of the more frantic music out there. Quality is top notch but if you buy used be sure to confirm what preamp it has, Spector players are an odd bunch, they like to constantly flip out their preamps for after market offerings. A Euro with a tone pump or HazLab or dark glass or OPB-3 preamp is truly something to behold. This is a bass that you can constantly change to fit your tone needs as your needs change without ever having to reroute PU cavities or buy new basses.
A used German Warwick Thumb bass can easily be had for $1500 or under and will have a grit and growl attitude similar to the Spector except a bit more woody, organic and less hifi sounding. Ergonomics on these can be a deal breaker for some so try before you buy. Unlike the Spector, most people keep their Warwicks stock, so you'll find a lot of similarity in sound from one thumb to the next (that's not necessarily the case with used Spectors). I can't think of another bass that sounds like a Thumb and it's a great sound that sits up front in the mix, it's not a P bass Motown wallflower.
By comparison the Corvette seems sedate, mellow and laid back, which can be a good thing if you want to sit in the mix as a foundation and underlying voice. The used German Corvettes can easily be had in the sub $1000 bracket and have less ergonomic issues than the Thumb. Same great build quality and again rarely modded so very similar sounds from one vette to the next.
A used Stingray can easily be had for $1200 or under and has a very unique scooped sound with tons of lows and glassy highs. Great for slapping, funk and classic rock. They can be heavy or average in weight and some prefer the original single Humbucker with the 2 band over the double buck with the 3 band while others prefer the opposite. I'd classify the 2 band single pup Ray as an updated active P bass. It's much more aggressive than a Precision and will sit more up front in the mix but if you roll off the highs it calms down into P bass territory. The 3 band double buck and H/S models start to enter into that Spector territory in sound but retain enough warmth to still work quite well in a classic rock setting.
A Fender precision is like an old pair of house slippers, comfortable, warm, cozy and understated. It's a no frills solid workhorse that delivers a no surprises sound and just beds into many different types of music. From a tool standpoint, it's a hammer. Every bass player should have one in their tool box and you can make it fit the task at hand regardless of what that task might be. All that said, I have several including a sweet 1968 but I just don't use them much these days because I have so many other more specialized tools in the box. If I was told I could only have one bass it would be a Precision but fortunately I've been blessed with the opportunity to own many basses so now I gravitate towards the best tool for the job vs the most versatile tool.
That's about it, and I'm sure there are many exceptions and differing opinions but generally speaking these are my experiences over a long period of side by side comparisons and ownership of these basses. There isn't a wrong answer in the bunch, all are built very well and sound fantastic it really comes down to you and what you're trying accomplish.