I mean, great general + knights with charge/rout can give muskets a hard time. The muskets don't have any real promotion that makes them better at fighting cavalry and sure they can get GGs of their own, except those come later.
It's actually very possible for your experienced knights to overrun untrained muskets.
It should be possible for just about anybody to 'overrun' Musketmen if they get through their (very short-ranged) Fire: the matchlock musket man after he had shot took almost a full minute to reload, and during that time he was armed with a short 'hanger' sword that he was completely untrained on, and a 20 pound clumsy wood and metal club. That's why, assuming 1470 CE as the date for the Arquebus/musket, 1493 CE, or 23 years later, is the first date for the Spanish Colunela, the first organized 'column' of troops combining arquebusiers, pikemen, and some halbardmen and swordsmen, into the first "pike and shot" unit. Realistically, the separate unit of Musketmen existed for about 2 - 4 Game Turns, because the poor critters were virtually defenseless against a determined charge by anybody without a wall, river, pikemen, barbed wire, minefields, or something to stop the charge.
... ssshhhh Waterloo ssshhhh
Good sum up though
At Waterloo/Mont-St-Jean the French Cuirassiers were shot to bits by British Squares, but the Grenadiers-a-Pled of the Old Guard were shot to a halt by British infantry in line, and retreated in the face of British bayonet charges and fire from infantry still in line.
And, of course, the major French infantry attack was shattered by the charge of the Union Brigade of heavy cavalry (Un-Cuirassed Cuirassiers, if you will): the whole thing was a prime example of the "Iron Duke's" ability to use Combined Arms against a French Army that, by 1815, should have been much better at properly coordinating their efforts.