At least for Italy, the teams usually represent your city (Roma, Fiorentina for example) or region (Lazio). Apart from Juventus, Milan and Inter (supported everywhere in Italy), supporting a smaller team often means supporting the city it represents, taking pride in it and of course hoping for the victory and success of the team. I wouldn’t say that victory is the main reason someone supports a team, sometimes it’s also good just watching the team