Could anyone explain the linguistics around the word "shit"?

When someone is "shit"... That's bad

When someone "ain't shit"... That's also bad

When someone is "the shit"... That's good!

???

Please help