Final Moments II: Observational Properties and Physical Modeling of CSM-Interacting Type II Supernovae