CLN: Merge_asof null error message
- [x] tests added / passed
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`

Post #23190 cleanup based on a review I wanted to give:

* `any()` instead of `sum() > 0`
* pytest parametrize

cc @jreback 