Americans do like their teams to be the best, but interestingly American individualism results in a strong tendency to cheer for the underdog. That preference is not true in other countries, where people want to be a fan of the best.
Americans really seem to love when their national team is the underdog—e.g., the Miracle on Ice.