REF: Allow Index._with_infer to also return RangeIndex
Would supersede https://github.com/pandas-dev/pandas/pull/58117

I see 8 usages of `Index._with_infer` in the codebase. There are some ops like `groupby` and `CategoricalDtype` that would nicely return a `RangeIndex` result if possible
This may be too aggressive so closing for now