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
why what does that accomplish? ``codes`` is a special case, so no point in doing an if/then inside the general accessor method.