Up to this point in my bass playing career I have never used pedals. I did try an octave pedal in a shop once and whilst the effect was cool, I didn't like how much of my bass sound was compromised when the pedal was turned off. If I was to use one I'd always want it to be like the SF-2 where I can keep the clean bass signal and add the effect to that.
I wonder what octave you tried? Pedal makers have gotten better at allowing the true, original sound through when the pedal is off - some of the old ones can be pretty bad! You can always use a switchable effects loop to take the pedal out of the signal when you don't want it, but I've never gone that far. I'm not going to encourage you either, pedals can be a rabbit hole, though certainly cheaper than amps or basses! Actually, did you use pedals much as a guitarist?
As a guitarist I also didn't want to use many and for many years it was just a wah pedal and the distortion from my fender twin. However when I was touring the states in 92 I didn't take any effects and the band leader wanted me to use some so he sold me a zoom effects unit that fitted onto the strap of my guitar and the controller was double side taped to the guitar and I used that for the first one. However I stopped for most of the second tour because whilst the sound was good through headphones it was too thin and noisy on a big stage when turned up loud. So I bought the ProCo Rat from a music shop in San Diego and requested a Fender Twin valve amp for my stage rig and that worked great.
Moving on many years later when I was touring with an indian/reggae fusion artiste he again wanted lots of effects so I bought a multi effects line6 XP Pro Live which I eventually hated for it's tone sucking abilities but the band loved the sounds so I loved with it but bought a LS-2 to bypass it when I didn't need any effects from it.
I also took my Roland midi controller and pickup for UK dates for the Indian sound effects like sitar tabla and voice. I haven't used that Line 6 unit thing since about 2007.
These days my guitar gigging days are few but I still have an analogue effects board and I use a boss LS-2 to keep a clean output until I need effects. But saying that, most of my time I use just a clean sound, wah and, Radial Trimode pedal if I'm using an alembic guitar or ProCo Rat for passive guitars.