Hurwitz-type Theorems for Automorphism Groups of Smooth $4$-manifolds