For about 90%* of players, no there is no point - they are happy playing standard tuning and if the music they play doesn't necessitate it, it is likely to be superfluous.
For my band, it is absolutely necessary. The guitarist is tuned to C#G#C#F#G#C# (or D♭A♭D♭G♭A♭D♭) and uses a capo also on some tunes, the B features quite heavily in most keys he plays and I have the ability to go up or down from his roots. In fact throughout our songs, there is no fret on the B string below 7 I dont use.
*This is apx data based on 2nd hand items for sale on eBay/Reverb currently.