There are a lot of opportunities for EQ in the long signal chain between your pickups and the house sound: Your guitar's tone knobs, the tone knobs on your effects pedals (when engaged), the EQ on your amp, the choice and placement of the mic on your amp, the EQ in the channel strip on the house board, the main house EQs, and maybe some others I'm not thinking of at the moment.
You have control over some of these, and some of these you don't control at all. If I think I need a touch more, say, bass in my sound, I could try to EQ it myself, but if the house engineer disagrees, s/he'll just turn it down on my channel strip. I generally assume that I have little control over nuances in my final tone, because the house engineer is going to tweak it however s/he needs to anyway. So I'll use my guitar and amp controls to get as good a tone as I can get, and then I don't worry about it much after that.
With that in mind, I think your use case for EQ pedals---as a boost and perhaps a slight tone shift for solos---is perhaps the best and only practical use case I can imagine for an EQ pedal.