Fixups for categoricals

This PR will collect the various fixups for Categorical.

See #8078 for the ToDos.

In the end should Close: #8074


Closes: #8077 -> API/FIX: wrap result cut/qut in Series and make it ordered
I don't think we should advertise `codes` here, maybe "False to return an array of integers, where each integer indicates a bin"