Active electronics works well for bass. On guitar the only one I played where it felt like the active electronics was something I actually liked using was on an old Musicman Sabre II. I don’t know what the preamp really did but on or off there was plenty of usable tones to be had.
I never felt that the common boost/cut 2-band or 3-band active EQ's on basses offered me anything that I couldn't accomplish with my amp EQ, so the 9v battery typically hasn't been worth it to me. The only exception being when it's a parametric type control with a sweepable frequency spectrum. I put an EMG variable mid control in my old Hagstrom Swede and it proves to be very useful on that bass; allowing mild tweaks to get the sound just right. As for state variable filters and Q controls, those are my favorite and really allow me to tap into another dimension of tone shaping.
I think the only active electric guitars I've come across in person were more geared toward metal music, which isn't really my cup of tea. The guitar playing I do is more limited than my bass playing, mostly just a song-writing tool and accompaniment to my singing. I like pretty chords and simple melodies, so I find the clean tones from an articulate neck pickup combined with flatwound strings and a simple little tube amp are just what I need to get me where I'm headed