Regularized and Renormalized Many-Body Techniques for Describing Correlated Molecular Systems: A Coupled-Cluster Perspective