Hydraulic fracture stimulation is one of the most effective methods to recover oil and gas from unconventional resources. In recent years, foam-based fracturing fluids have been increasingly studied to address the limitations of conventional slickwater such as high water and chemical consumption, environmental concerns, and high incompatibility with water-sensitive formations. Due to the gradual breakdown of liquid foams at reservoir conditions, the combination of silica nanoparticles (SNP) and surfactants has attracted a lot of attention to improve liquid foams' characteristics, including their stability, rheology, and proppant-carrying capacity. This paper investigates and compares the effects of cationic and anionic surfactants on the fracturing performance of SNP-stabilized foams at the reservoir temperature of 90 degrees C. The experimental results of viscosity measurements were imported into a 3D fracture-propagation model to evaluate the effectiveness of fracturing foams in transporting and distributing proppants in the fracture system. At both ambient and elevated temperatures, cationic surfactant was experimentally found to have better synergistic effects with SNP than anionic surfactant in improving the apparent viscosity and proppant-carrying capacity of foams. The simulation results demonstrate that fracturing with cationic surfactant-SNP foam delivers greater performance with larger propped area by 4%, higher fracture conductivity by 9%, and higher cumulative gas production by 13%, compared to the anionic surfactant-SNP foam. This research work not only helps validate the interrelationship between fluid viscosity, proppant settlement rate, and fracture effectiveness, but it also emphasizes the importance of proppant placement in enhancing fracture conductivity and well productivity.