There are a few older threads on this forum that list merit and need based awards that people were willing to share. I administered the thread for the class of '22 admission season. Here’s a link- you’ll see that there are awards (and non awards) in programs of all levels, and not just the schools that are ‘lower levels’. I’m sure this changes year to year but perhaps this sample will be helpful for some context.
Schools with grad programs (like Northwestern, Juilliard, IU, etc) often reserve their funds for grad students, but schools like Oberlin, with no grad programs in performance, give merit awards fairly regularly.