 CLN: avoid upcasting in tests where unnecessary (PDEP-6 precursor)
another precursor to PDEP6, similar to https://github.com/pandas-dev/pandas/pull/52957

getting there...I think most of the remaining ones are when the test explicitly checks for upcasting behaviour, and so probably can't be changed right now
Thanks @MarcoGorelli 