What schools offer generous merit aid

Thanks!
My son would prefer to stay in CA for several reasons, but might be persuaded to go elsewhere if it made sense to him.

I was hoping that some slightly lower tier universities might offer significant merit aid (e.g. my brother was awarded a full ride at a good regional school years ago), realizing that the top tier doesn’t need to entice students to attend.