has anyone figured out a way to get a great blended acoustic and electric sound?
Yes. I have made a blended profile. I have a Hamer Duotone which I use to do a profile of piezo blended with magnetic pickups. The Duotone has both types of pickups and both are available on separate outputs.
There are two key factors you need to keep in mind in order to get a good result. The process is pretty complicated. You will need a mic, a mixer, and a FRFR powered cab.
Remember that you can use multiple streams of audio to make a profile as long as you have a mixer that can mix to a mono output.
Usually, I connect the piezo output of my Duotone to my Fishman Aura preamp. However, if I want to really emphasize a more mic'd up acoustic sound, I connect to my Universal Audio Apollo. Then I load the Sound Machine Woodworks plugin. Woodworks is pretty amazing. The Aura has some nice models of acoustic guitars, but Woodworks is even better at making a piezo pickup sound like a totally acoustic guitar with a mic on it. It's not like the Aura sounds 'bad'. It just sounds more piezo and Woodworks sounds more acoustic. With either method, I connect the output to a channel on my Mackie mixer.
I have two methods I use to get the sound from my guitar's magnetic pickups. For quick results I use a Radial JDV direct box which connects to another channel on the mixer. To fatten the signal up a bit, I occasionally connect the JDV to an Apollo mic input and load a Neve 1073 channel strip. I turn the compressor off, and set the EQ to flat, just using the gain to add a little to the signal.
Or I sometimes connect my guitar to a Hi Z input on my Apollo and select a Unison amp sim plugin. If I do that, I set the plugin to a very clean output. The idea is to add a bit of tube amp feel, not to add drive.
The trick is to keep the magnetic signal clean so it blends really well with the piezo signal.
Whatever method I use to set up the mag pickups output, that stream goes to the Mackie on a second channel. The Mackie is connected to a Line 6 L2M FRFR powered speaker, set to flat. I mix the two channels to mono. I use a good condenser mic on the L2M, which is connected to the Kemper's input. Then I make the profile.
A few notes are warranted here. I experiment a lot with the mag pickup stream's sound. In some cases, I like the neck pickup best. Sometimes, I like the neck and bridge pickups combined sound. I don't generally like to blend the bridge pickup by itself with the piezo sound, unless I dial the volume back a bit and turn the tone down.
I also have experimented with using a tube guitar preamp on the mag pickup sound. When I do, I generally find that it is best to keep the gain down. But sometimes adding a bit of punch to the mag sound can create a magical result when blended with the piezo sound.
I can get a nice blend of an acoustic and magnetic pickup sound using the above methods. But it important to note that there are some limitations to your tonal range when you do this. First of all, because you are blending the two sounds, if you add an effect to one, you are adding an effect to both. Second, you lose the nice stereo effect that you can get when you keep the two sounds on separate channels, with two amps. Third, if you keep the two sounds on separate channels, you can blend or play either separately at any point in a song.
Note that you can also get some great blended profiles made with two tube amps for your mag pickups. You set up the same way you'd set up to make a Studio profile with a single amp and multiple mics on the cab. The difference is that you use a mixer and mics on each amp's cab, then mix the mics to mono to send a mono signal to the profiler. The Kemper only cares that it is getting a mono input to create its profile.
I have made profiles by using a blend of the Mesa preamp and one side of the 20/20 and the AB763 clone and the other side of the 20/20. The 20/20 is actually two separate 20 watt EL84 amps. When I set up in stereo like this, I use exactly the same cabs on both sides and I use the same model mic on each cab. Each goes to a separate channel on the mixer, getting mixed to mono.
The slight difference in tonal character and gain between the two preamps can make for a really awesome profile.