Can I make almost any bass work on a gig? You bet I can. If you need to play short scale basses for ergonomic and health reasons, and can’t get the sound you need for your band(s), I would look at your amp and cabinet(s), not the bass.
This sounds like great advice!
After cervical spine surgery I was fortunate to have my benevolent guitar player friend loan me his Hofner violin bass. That is a bass I have zero interest in under normal times but the lightweight was a godsend during recovery. I had to play with my amp alot to get a tone I liked with it. Just think it shows EVERY bass is a different beast regardless of scale.