I was thinking of American 587. Its amazing how airliners can go from flying to stalling and into full pancake mode without dropping a wing.

That comes down to simple airmanship. You don't need anything to tell you about energy state when landing to prevent an overrun. Fly the appropriate speed and AoA, and land, don't hold it off until midfield, and calculate the landing performance in advance. Now you know, before you go.

Simple airmanship.

It’s very aircraft dependent. In many if not a majority of aircraft ailerons introduce adverse yaw when deflected at high AOA. The quickest way to end up on your back in many high performance aircraft was using aileron to try and pick up a wing at high AOA.

Unfortunately, some DO need these warning systems. The Colgan accident for example.

And knowing...

Because the warning system was used and heeded so effectively by the Colgan Captain? I have no problem with a stall warning system, but it's presence in no way guarantees a positive outcome as evidenced by the very accident you cite. A stall warning system doesn't do much good if the user ignores it and pulls harder.
Like JB said, it's simple airmanship. The ones who truly "need" such a warning system to be safe are probably in the wrong line of work.

So you're saying you had alpha?

https://youtu.be/335GdTqtyLs?t=59

Yeah giving the problem children more info won't usually solve the problem.

And to take it an extreme case, IIRC, the AK C17 crash.

No. Not remotely so.

For starters, that mishap had nothing to do with landing long or an overshoot, so the original assertion that additional displays indicating potential float at roundout" and overshoots, is irrelevant.

The colgan mishap had ample warning information, none of which was needed, and the reaction to that warning information was incorrect...all the way to impact.