I personally really love the Fate system - it’s much more hackable than other systems, so if a part doesn’t work for you, you can usually tweak/remove it, and it sells “system toolkits” which essentially are homebrew guides.

Overall, I find most heavy systems tend to put a crazy amount of focus on combat, which skews stories into pigeon-holing combat whenever possible. Most players I run for tend to view combat as a last-resort, so it’s hard to find heavy systems that match their playstyle.