Tabletop Roleplaying Games

I’m relatively new to the hobby since I began playing in late 2019, but I discovered that the narrative and rules-loose games are not for me, so my question would be ”How little is too little?".

I’ve played some narrative campaigns using the Stalker RPG (diceless narrative), Ironsworn, FATE and I ended up loathing purely narrative systems. Now it’s been 6 months since I started to play solo and I keep buying new systems whenever I can, but as of now, I’m completely enamored with 5e adaptations like CARBON 2185, and other systems like Lancer, Twilight 2K, Shadowrun, Mutant Year Zero, and Savage Worlds’ Settings.

Maybe my perspective would change if I went back to play with more people and had to wait 25 minutes to play the next 6 seconds of my actions, on a fight that would take 2 IRL hours to resolve, but as a solo player, what I want is plenty of improv and creativity for the lore/narrative parts (which is why I appreciate lore books and supplements) but complex, high-stakes board/wargame mechanics for the build/combat segments without a GM fudging rolls or events to maintain me alive or to add drama or keep the story going, which was my resumed experience with narrative systems.

I assume the game that puts out 3+ books a year is D&D?