This paper presents a quantitative assessment of the value of hydroelectric power plants (HPPs) in power systems with a significant penetration of variable renewable energy sources (VRESs). Through a capacity expansion planning (CEP) model that incorporates a detailed representation of HPP operating principles, the study investigates the construction and application of HPP rule curves essential for seasonal operation. A comparative analysis is also conducted between the proposed rule curve formulation and alternative modeling techniques from the literature. The CEP model optimizes installed capacities per technology to achieve predefined VRES penetration targets, considering hourly granularity and separate rule curves for each HPP. A case study involving twelve reservoir hydropower stations and two open-loop pumped hydro stations is examined, accounting for standalone plants and cascaded hydro systems across six river basins. The study evaluates the additional generation and storage required to replace the hydropower fleet under high VRES penetration levels, assessing the resulting increases in total system cost emanating from introducing such new investments. Furthermore, the study approximates the storage capabilities of HPPs and investigates the impact of simplified HPP modeling on system operation and investment decisions. Overall, the findings underscore the importance of reevaluating hydro rule curves for future high VRES penetration conditions and highlight the significance of HPPs in the energy transition towards carbon neutrality.