To me this is a huge consideration, before you even begin talking about FOH. If you play guitar and don't like what you hear, nothing else matters.
In fact, I almost returned my Kemper the first week I had it because of the quality of profiles. As it turns out, I didn't understand the difference between a profile (snapshot of a tone) and an amp simulation (here's all the knobs, do what you will). I just saw Marshall and expected it to sound like my Marshall, but I play classic rock and most of the Rig Exchange tones were dialed in for metal. And they may be awesome for metal. For classic rock, not so much.
The only reason I kept the Kemper is that I found profiles that gave me exactly what I wanted to hear, for the style of music I play, when I strap on the guitar. In fact, they sounded better than the tones I was getting out of good tube amps (I kinda suck at dialing in tone).
Most of my favorite profiles for classic rock are MB, and it's well known that they tend to "come alive" at gig volume. I also like them in a recording context, and it was the latter that I used when searching for profiles. I'm just guessing here, but since you did your record I'm wondering if you might have auditioned profiles in the same context.
If so, it might be worth you doing another profile search, but testing them all at the loudness you use when working with your drummer. I'd even use a db meter in front of your tube amp with your drummer first, so that you could then play at the same level and see which profiles held up and which "collapsed." Maybe it's the Kemper power amp (if so, as I mentioned you might test other power amps). However, just as MB profiles "come alive" at gig level, maybe other profiles are optimized for studio and shine most brightly in that context.
Also, I spent a lot of time looking at free rigs on Rig Exchange. There's good stuff there, but I decided to see who was doing well regarded commercial profiles. My logic is that someone who does this as a business might do it frequently enough to gain significant skills at it, so (maybe) it would be less of a hit or miss proposition.
Another thing that I believe is absolutely crucial to getting the right tone is to find profilers who are into the same style of music as you. I truly love the MB profiles for classic rock, but I doubt that he'd be the first call for a metal guy. A profile is a snapshot of a tone - after someone dialed that tone in. If the person doing the profiling isn't passionate about your kind of music, how could he dial in a great tone for it?
So, if you haven't already, I would do another tone search. Do the auditions at gig volume (if you can blast backing tracks of your band through the PA for a full frequency comparison, even better). If you haven't already, search for commercial profilers who are passionate about your genre of music. Then, if you find a profile that can make you feel good at full volume, I think the FOH thing won't be an issue. You'll like what you hear on stage, as will the guys in the mosh pit (if they even do that anymore), and the FOH guy is gonna tweak your inputs anyway to make it sit in the mix.
For what it's worth, I believe it's possible for you to get what you want out of the Kemper, but it's all about the profiles, man. If all you've found are poor profiles for your taste, then you can't move forward until you skin that particular cat.