[noisenotsignal]

My university had lecturers that were precisely this (masters in CS, focused on teaching intro undergrad courses).

However, I think there is still a lot of benefit from having researchers teach upper level courses. Firsthand experience in research brings an additional dimension that can be appreciated by students who are beyond the introductory level.

There are also tenured professors who are good at both research and teaching!