I think Bayerlein was one of those commanders who had the less favourable set of features/skills and was given an ungrateful task even a military genius would have found daunting.
Bayerlein was a very skilled administrator and army manager who was also quite competent at leading troops in combat. He did however lack that self-aggrandizing larger-than life personality that many generals seem to cultivate and propels them into the history books because it's so much fun writing about them. Baylerlein's bio reads like "The guy did mostly OK" Hardly a page-turner.
And then he got stuck in Normandy a battle would make any general look like a fool because it was the dirty business of attrition, no fancy maneuvers, no heroic charge that changes the course of the entire battle (no, Wittmann doesn't even come close …) That's why the Panzer Lehr with all its promise couldn't do much more than slowly get ground to pieces. It was impossible to disengage the Panzers and keep them in reserve to smash the inevitable allied breakthrough.
And once again he's stuck in the Ardennes on a battlefield that gives you zero room for maneuver in an offensive where the attackers is more like the hapless defenders of 1940 and the defenders are more like the attacking Germans of 1940 but with superior logistics, equipment and a solid doctrine.
In military history you get a handful of geniuses who can pull off miracles, a few more highly competent people who stand out once or twice and then you have a huge chunk of the quietly competent guys who usually did good if conditions were on their side and did poorly if conditions were adverse and only occasionally got a lucky break or a really bad day.
Bayerlein was one of those guys who did his job within acceptable parameters, winning some, losing some. The invincible general defeating all his foes with disconcerting ease is very much the exception, never the rule.