Do you want the good news first, or the bad news? OK, I'll give you the bad news first: Almost everyone underestimates how competitive piano is. Because there are hundreds of pianists graduating each year from American music schools alone, there is a huge glut of pianists. That doesn't mean anyone should not go into the field. They shoudl just know what they're up against, and be willing to find a musical niche for themselves.
The good news is related to the bad news: Because there is a glut of pianists, there are a lot of really good teachers at some schools you may not think of at first. SUNY Stonybrook is one, UMKC, USC, U. Mich. are others. BTW, Berklee - I assume you mean the one in Boston - is more for popular music and jazz.
The days are long over when Julliard, Curtis, NEC, Eastman, and Oberlin were the only viable options for piano students. There are a lot of good schools out there.
As a rule of thumb you should not pick a school because of the name, you should pick a school because of the piano faculty. The more you can establish a connection with the faculty - through taking a few lessons, etc - the more you have an "in." Also, to make things more complicated, you might see a big name listed on the faculty roster, but he/she might not take many new students. One example is seeing Leon Fleisher listed on the faculty of Peabody Conservatory. He's such a busy guy, it's almost impossible to get into his studio (and if you do, how many lessons do you think you will have with him?).
To even further complicate things - and to slightly contradict what I just said - it's important to have a good "name" school somewhere in your academic life - undergraduate, masters, DMA. If you go to a small state college without a big name for undergraduate, you should try for a bigger name for graduate school.