DEPR: DataFrame.__getitem__[str] sometimes slices on index
xref #31334, #9595 

- This is a tiny corner case, at least as measured by tests cases (2 tests reach this)
- With this removed, the `__getitem__` API becomes much simpler to describe: "DataFrame.__getitem__` is always column-based"