DOC: Clarify output of diff (returned type and possible overflow)
- [x] closes #28909
- [x] tests passed
- [x] passes `black pandas`
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] note about dtype in `diff` in Dataframa and Series
