I subscribe to the Anthony Jackson school of thinking that the 6 string Contrabass is the 'full' representation of the bass guitar. It's was a very young instrument when Anthony started to innovate on the number of strings, as well as being one of a cadre of bassists who really challenged and changed how we approach 'playing bass'.
I don't really play fives anymore because if I'm going to have a low B I'll typically want a high C. However, my favourite bass is a four string and I am ultimately most comfortable and happiest on a four string. I love having the extra notes available on a 6 string bass but I also love the flexibility it gives in moving across the neck in one position and the extra chord voicings it gives.
A lot of the more melodic things I transcribe, I do on the G string when playing a six, even when it might have been more appropriate to use the C string because I want to learn patterns I can take over to the four string very easily. On some pieces, this doesn't work but I try to do that where I can so I can play the part on a 4 string without changing the fingering.
There are few gigs you really need a low B for but it's mandatory for some. Detuning can work as a band aid but it's not a complete solution.
I'm in the same place. Have a pair of 4-strings that are my keepers, have a 6-string for when I want extended range. I played nothing but 5-string for about a decade, 4-string before that, mixed it up after including a 5-string strung E-C. After a number of failed 6-string attempts it finally stuck, but really it was embracing the idea of the 4-string as the "core" and if I wanted extended range, I wanted it in both directions. Totally YMMV.