Backport of #27695.

Closes #27622. The issue stemmed from #25186 which was patched in #25361, #26156, and #25337 but really the original change should have been scoped better.
Essentially:

• The common block issue was fixed by a broad change to the way F2PY handled modules, causing BUG: Modules from Fortran interface not accessible in Numpy 2.x (current 2.1.2) #27622 and BUG: Fix regression with f2py wrappers when modules and subroutines are present #25361
• The right approach is to only skip if common blocks are present
  This simplification (and additional test) ensures backwards compatibility.