ENH: allow opt-in to inferring pyarrow strings
cc @phofl 

Enabling this at the top of conftest.py breaks 4290 tests.
I'm not as invested as you in getting this in for 2.1.  Want to take over this PR? I have some trouble pushing to other forks, opened #54430 with tests and removed the comments Closing in favor of #54430