I don’t think research is all that important, especially for an undergrad who is uninterested in participating in research and/or getting a PhD or other academic graduate degree. There are lots of great liberal arts colleges and regional public universities with low research outputs, but where the professors are focused on providing the best educational experience for undergraduates at the college.