made path_or_buffer rely on position
- [x] part of  #54616
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

Thanks for the PR but https://github.com/pandas-dev/pandas/issues/54616 is still under discussion and not ready for a PR yet so closing for now. Feel free to tackle any other unassigned issues labeled `good first issue` @mroeschke for context, this was done together at a sprint. I agree it certainly still requires discussion (and for that I opened https://github.com/pandas-dev/pandas/issues/54616), but we felt it could already be useful to start with a draft PR. This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this. Thanks for the pull request, but it appears to have gone stale. Let's still take the discussion to the issue before moving forward here so closing for now