Ooh, that’s a can of worms question for a bass forum!
I think I’ve been through more P Basses that I’ve had hot dinners. In your situation, I’d be looking at a 50’s MIM P Bass or a used MIA P Bass, but that’s just because I like a Fender. The Yamaha is great, or a second hand Tokai. Limelight etc. Something like this one in the link is great value, and is what I’d buy in your situation.
The only one on your list I’d avoid is a Std MIM, though I’d happily use one anytime, it’s just that if you can spend a little extra I believe it’ll go along way with the right bass.