Northwestern, University of Chicago, Columbia, Dartmouth, Princeton, Yale all excel at undergraduate teaching while also conducting lots of research.
Excellent teaching of undergraduates & superior research efforts are not mutually exclusive.
The US News ranking for undergraduate teaching is hard to accept. Georgia State in Atlanta, for example, is ranked at #4, while Chicago, Columbia, Penn & other stellar universities do not make it into the top 60. The US News rankings appear to be based on little substance.
P.S. It might be more helpful to ask which among the top 50 National Universities & Top 50 LACs are great at undergraduate teaching. I suspect that the answer would include almost all, possibly all, of these 100 colleges & universities.