I'm basing my opinion in this analysis of ACOUP (Brett Deveraux), who's a military historian and specializes in dismantling this kind of pop culture myths.
https://acoup.blog/2019/09/20/collections-this-isnt-sparta-p...
While the Spartans weren't a disaster, and in some respects they were marginally better (but in others, worse), the statistics don't lie: they had an average track record, certainly not on par with their current reputation. They didn't excel at any particular strategy, they were just hoplites like every Greek at the time. Their track record is disappointingly average:
> We get 12 victories, 11.5 defeats and 0.5 draws
Hardly impressive, right? And this is excluding naval battles, if we include them the Spartans do slightly worse.
> Sparta had a formidable military reputation, but their actual battlefield performance hardly backed it up. During the fifth and fourth centuries, Sparta lost as often as it won. Spartan battlefield tactics were a bit better than other Greek poleis, but this is damning with faint praise. The spartiates themselves were mostly like every other group of wealthy Greek hoplites. But the Spartan military reputation was extremely valuable – the loss of that reputation during the Peloponnesian War does much to explain the rough decades Sparta would experience following its end.
He also explains Sparta was also a self-defeating, ever-shrinking society, which ultimately proved to be its demise. But you're not disputing this, so this is just a side note.