Injecting carbon dioxide (CO2) as foam during enhanced oil recovery (EOR) can improve injectate mobility and increase sweep efficiency. Integrating CO2-foam techniques with carbon capture, utilization and storage (CCUS) operations is of recent interest, as the mobility control and sweep efficiency increases seen in EOR could also benefit CO2 storage during CCUS. In this study, a variety of different charge, hydrocarbon chain length, head group surfactants were evaluated by surface tension, bulk and dynamic CO2-foam performance assessments for CCUS. The optimal foam candidate was expected to provide satisfying mobility control effects under reservoir conditions, leading to an improved water displacement efficiency during CO2-foam flooding that favors a more significant CO2 storage potential. All tested surfactants were able to lower their surface tensions against scCO2 by 4-5 times, enlarging the surface area of solution/gas contact; therefore, more CO2 could be trapped in the foam system. A zwitterionic surfactant was found to have slightly higher surface tension against CO2 while exhibiting the highest foaming ability and the most prolonged foam stability with a relatively slower drainage rate among all tested surfactants. The dynamic performance of scCO2-foam stabilized by this zwitterionic surfactant was also evaluated in sandstone and carbonate cores at 13.79 MPa and 90°C. The results show that the mobility control development in carbonate core was relatively slower, suggesting a gradual foam generation process attributed to the higher permeability than the case in sandstone core. A more significant cumulative CO2 storage potential improvement, quantified based on the water production, was recorded in sandstone (53%) over the carbonate (47%). Overall, the selected foam has successfully developed CO2 mobility control and improved water displacement in the occurrence of in-situ foam generation, hence promoting the storage capacity for the injected CO2. This work has optimized the foaming agent selection method at the actual reservoir conditions and evaluated the scCO2-foam performance in establishing high flow resistance and improving the CO2 storage capacity, which benefits integrated CCUS studies or projects utilizing CO2-foam techniques.