Usually people in capital cities aren't very friendly, but I found the people from Rome very nice as opposed to Madrid, for example.
I don't want to offend anybody, but I found very few friendly people in Spain.. maybe because I'm from Latin America and I travel with an American passport? Who knows..