DOC: Fix inconsistent and incomplete documentation of `pandas.eval`
- [x] closes #58338
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).

This PR implements the suggested documentation improvements outlined in #58338:
- Covering the supported operators and functions to `pandas.eval`
- Reorganising and adding links to  `pandas.DataFrame.eval` and  `pandas.DataFrame.query` to have a consistent explanation of the `expr` parameters
Thanks @JonathanMarriott 