I discovered the upright (or double) bass through rockabilly music, though I moved more into a folk realm with it. The natural weight and “bloom” of an upright is something you just can’t get anywhere else. It takes up just the right amount of space, like water; it takes on the shape of its vessel – in this case, the song.
Emma Hill’s “Am I Talking to You” is a good example.
Sometimes electric bass is just the right choice. But why not have both? “Existential Midlife Crimes” by Small Souls features electric bass in the verses and upright in the choruses.