If all the available map projections seem overwhelming, you might want to check out a recent Esri publication, Map Projections in ArcGIS. This Story Map app provides brief explanations as well as examples for 68 featured projections.