DEPR: Enforce disallowed merging scenarios
Introduced in https://github.com/pandas-dev/pandas/pull/34810, https://github.com/pandas-dev/pandas/pull/40993, https://github.com/pandas-dev/pandas/pull/40991

lgtm excluding failures Merging. Appears failure is unrelated