I can only think of one in Stars Wars Rebel Strike off the top of my head, and yeah it sucks
Star Fox Assault also kinda sorta has it, the two times where you're shooting while riding on the wing of a ship, but either way I think you're onto something, turret sections are just inherently not fun