In light of current energy policies responding to rapid climate change, much attention has been directed to developing feasible approaches for transitioning energy production from fossil-based resources to renewable energy (RE). Although existing studies analyze RE's regional dispatch and capacity planning, they do not fully explore the impacts of the energy storage system (ESS) technology's technical and economic characteristics on RE integration and energy transition. To fill this gap, we propose an integrated optimal power flow and multiple criteria decision-making model (OPF-MCDM) to minimize system cost under operational constraints and evaluate the operational performance of ESS technologies with multiple criteria. Through analysis of hundreds of scenarios, the proposed method can identify the most critical features of ESS technologies to enhance RE integration and achieve New York State's climate goals from 2025 to 2040. For example, we discover that hydrogen energy storage (HES), with the highest energy loss values, requires greater installed capacities (7,419 MW of RE and 398 MW of ESS) than the lithium-ion battery (LIB) in 2040 and generates 4.2% more carbon dioxide emissions than LIB on average. Based on the cross-sensitivity analysis in the multidimensional evaluation, underground compressed air energy storage (CAES) performs the best, and HES performs the worst when reaching zero carbon dioxide emissions target in 2040. The proposed OPF-MCDM’s results can also be conveniently generalized to select ESS technology based on the criteria preferences from RE integration and energy transition studies and serve as a reference for ESS configurations in future energy and power system planning.