I’ve been in this dilemma too and would reiterate the comments that you ideally want to like your fundamental amp and bass tone and use pedals as flavouring etc
Been down the pedal road as a guitarist and it’s hard to be satisfied and I always end up thinking too many pedals etc end up destroying the true sound of the instrument but I guess many are true bypass now but it’s still more cables, power supplies etc etc
The only pedal I’m considering is a light overdrive pedal to kick in on occasion to fill the gap when guitarist is widdling etc
It’s good fun experimenting but can get costly
Dont overlook the low cost pedals as many are as good as high end boutique stuff