Having had a read of your post, I think scale wise DR would fit, also Heroes in units can die during battle, and with a test for activation has some scope for Solo play.
As I'm looking at it for a GoT as it has undead units. I would also add that a Viking in the Sun LR standalone ruleset also has a version of Greek Fire for rules for that explodey green stuff used against the High Sparrow and a Fleet of ships.
Other options maybe Never Mind the Billhooks, Andy Callan referenced LR as one of the inspiration in its design, and there is now a fantasy version and the rules has a card drawing technic so need the cards too also playable solo. Has some logistics, and there is a nevermind the boothooks you may want. Ship combat occurs in GoT, and has logistics, arrows can run out...
Barons War maybe more the 30 guys a side are getting a Fantasy Version, a logistic consideration here is mounts can only charge once or twice then there tired or injured/dead and you'd have to dismount.
There were also articles in Miniature Wargames 395 for GoT adaption from Middle Earth Strategy Battle Games, Wargame soldiers Strategy 74 for modelling advise, and more covers all points overview in Wargames Illustrated 386 for Wargaming games of thrones.
You may find that with DR as the base using elements from LR and Nevermind the Billhooks may get you what you want, as for charging, unless 1 big block of guys, multiple units assulting the same target would hit in waves anyway they didn't have a means of co-ordinating by someone firing off a very pistol fired off to all charge, or at 0100 exatly etc, CnC beng what it was back in the day. If anything the hitting together if not in one combined mass is unrealistic. The nuance of LR/DR imo is the activation and the units that do better on attack/defence with glass cannon cavalry, and how you use/cover your skirmishers and cavalry. not quite the rock/scissors as someone else mentioned though there is an element of that.
Is there a particular setting you want it for? As Midgard may more fit also as another option.