PERF: fix performance for series slices (even more)

This is a continuation of #6341 and is related to #6370. The latter unfortunately concerns public API and may be not easy to fix gracefully.

So, regardless of the decision to be made in other ticket, this patch will optimize series slicing right away and remove some redundant code (no need to override `__getslice__` because `Series` doesn't inherit `ndarray` anymore).