You don't have to go for the 80s mwaah - raise the string height a bit, play dead strings or add a foam mute, and you can get a lovely warm vintage electric bass sound, like a Hofner, or near to an amplified upright bass sound with the right tone dialled in. I play fretted and fretless, as Frank mentioned earlier, the freedom of expression you get with a fretless is very different.