I bought a good friend a second hand acoustic bass guitar about 7 years ago or something, for his birthday. He has a Fender Jazz, and Stingray. The first thing he did was send it into a shop to get the action sorted, which made me realise how much he valued it, to invest in it. I went back in August and it was stood in his front room with the others. He says he plays it plenty and has done a few session jobs with it too. I'm can't recall if I knew when I bought it, but I was surprised that the frets were marked, but weren't actually frets. meaning it gave him a even different sound than he has as both his electrics are fretted. He's a big Jaco fan too.
I understand fret noise is a big issue, but some like that character, but if you were looking to replicate an upright more, then maybe fretless is worth considering and they could be marked to help the transition.
I like the sound of an acoustic, noticed a while back that Sigur Ros sometimes use one, and just yesterday was listening to the Alice in Chains unplugged session, they used an Acoustic too.