I understand the desire for tonal variety. If you are hape with the p sound and just want more options a pj would be a good choice.While I do think it can do the job, the frets are a bit noisy no matter the setup, everything else is fine about it but the tone is pretty restricted due to its 1 P pickup and I would like a bit more variety.
Otherwise look also into a Jazz bass. Different sounds and different feel. yamaha in general is a good choice but no brand is free of issues. the individual instrument is more important than the brand.