Edit: Correct me if I am wrong, but I guess my current position will now have 10mm less saddle-to-bar drop. 5mm from the longer stem and 5mm from dropping the seat post when I adjusted the cleats. So it would make sense that I can drop the front end 10mm while maintaining the same drop as before?!?
I would slow down on the changes and make them one at a time. I am not a fan of midfoot cleats and therefore not well-versed in the adjustments required as a result, but you are going all in on an Ironman-style bike fit.
Purely from a motion diagram perspective, a typical rider's kinetic chain extends up to their lumbar spine--maybe up to the thoracic spine when out of the saddle. Assuming perfectly rigid shoes, midfoot isolates/reduces stress on the lower parts of that chain, shifting work upward. That alone makes the quad do more work. It also removes from consideration a bunch of potential solutions to balancing your pedaling effort across more of your body.
Closing the hip angle and increasing the distance the upper leg travels during the stroke both tend to increase glute recruitment, but this doesn't really map to saddle lower vs. higher if you are already opening the hip angle via a forward position. Your ankles also affect the overall distance the upper leg can travel. By switching to midfoot, you also limit ankling's potential contribution to upper-leg movement.
IMO, most non-triathletes should be using their calves as much as they can if they want more glute recruitment (it's better for your knees too!), as it gives you more freedom to find a fit that works across more of your kinetic chain. If you have really developed calves, a good cleat position is probably close to the ball of the foot; if you don't, it's probably about ~10 mm behind. Experimentally, I would move them forward till you can feel it on long rides, and then move them back slowly until calf soreness isn't an issue.