Cooperation and competition in the collective drive by motor proteins: Mean active force, fluctuations, and self-load