It doesn't bother me before games and it does occasionally stir emotions inside me about how incredible and special our country is. That said, I see the point that it isn't really needed to be played at college games. However, it IS crucial and important to play at U.S. international sporting events, in my opinion. It is awesome at U.S. soccer matches, and it leads to a lot of people singing in unity with the same passion for the USA, USA, USA. Also, the same with say our USA basketball team playing it before exhibitions. It means a lot more in that context when countries are playing each other compared to before domestic league games.
So, I guess if I was making the decision, then I say we keep it to remind ourselves of the bonds we share as Americans and how special our country is.