Wormholes as perturbations of near-horizon black hole geometries: No-go theorems within effective field theories