I'm sort of seeing what people would like to happen rather than quoting events and making rules that fit actual situations.

The Historic situations where Hoplites lost to Cavalry (or Cavalry and Light Troops) generally involve loss of other troops on the side of the Hoplites and then envelopment/ flanking.

I don't understand the historic basis of downgrading of Long Spear Vs Cavalry really.....I don't have a closed mind on this, but I don't see the evidence to support it.