I find myself frustrated and stuck in terms of games to run. On one hand I enjoy the mechanical complexity and verisimilitude a detailed RPG system brings. On the other hand this can become incredibly restricting and result in players attempting to resolve everything mechanically rather than narratively.
Narrative based systems resolve this by ignoring such mechanics in favour of much looser and broader scene setting and the idea of 'failing forwards' This allows for far more dramatically compelling games but at the expense of a GM being able to create and run a realistically compelling world with internal rules that mechanically make sense and aren't just based on endless 'mother may I' rolls.
Is there a system with a happy middle ground between the two?
Use a point-based system
>>54164643
Legends of the Wulin is great for having detailed and interesting narratively-focused combat
Burning Wheel is a rules-heavy character driven game. Although most of the detail is modular so it may not suit you too well.
>>54164643
Barbarians of Lemuria has just enough crunch. Check it out. Ignore the lore.