In my visits to Mexico (both to tourist areas and far away from tourist areas) I've found Mexicans to be pretty friendly towards Americans. There are always a few who are less friendly, but in general I always felt welcome, especially in rural areas.
I've however, never spent much time in a large Mexican city. I suspect that the hate filled liberals are more concentrated in the cities there like they are here.