I change the batteries in all my active basses at least once a year - 8 batteries across 6 basses. I have used the Amazon 9v the last couple years without issue. I just got a pack of Energizers for the next round, and am planning on swapping those out this week.
I feel fine/safe using a medium quality battery and changing it out regularly. Mainly I see batteries leaking after they have been left in place for years, and I've seen fancy batteries leak in places where cheapos had no issue. Yes, I'm sure the failure rates are lower amongst the better battery brands. I think the main thing in battery husbandry is vigilance. Check on 'em. Change 'em regularly. Nothing worse than a battery going dead in a gig... except one exploding in yer bass!
I am ashamed to admit I change the batteries in my basses MUCH more frequently than in my smoke detectors, haha!