TYP: misc return type annotations
After this most of the low hanging return annotations that `pyright --createstub pandas` finds are in pandas/core (there are still plenty of more tricky return annotations).

xref #47521
Looks like the rebase with main is a little off > Looks like the rebase with main is a little off

I fixed it and forced pushed thanks @twoertwein 