Sovereign wealth funds (SWFs) have evolved from passive stewards of commodity windfalls into active, state-directed catalysts of structural economic transformation and fiscal income diversification. This study examines the institutional mechanisms, capital deployment strategies, governance architectures, and macroeconomic effects through which SWFs finance non-resource development, focusing on the Saudi Public Investment Fund (PIF) under Saudi Vision 2030. Employing an embedded mixed-methods comparative design, the analysis benchmarks the PIF against four funds embodying distinct operational models: Norway's Government Pension Fund Global (GPFG), Singapore's Temasek Holdings, Abu Dhabi's Mubadala Investment Company, and Malaysia's Khazanah Nasional. The qualitative strand synthesizes thematic content analysis of official disclosures, strategy programs, and credit assessments, while the quantitative strand estimates panel fixed-effects models linking SWF domestic investment intensity to multidimensional diversification indicators over 2000–2025. The findings indicate that active strategic development SWFs (SDSWFs) generate positive but non-linear spillovers on non-oil gross domestic product (GDP) growth, employment, and foreign direct investment. Domestic capital deployment exhibits diminishing returns beyond an estimated threshold of approximately 10.7% of GDP, past which risks of private-sector crowding-out, asset inflation, and bank credit absorption intensify. Governance quality significantly moderates whether domestic deployment translates into tradable export complexity. The comparative evidence positions the PIF as distinctive in scale, speed, and breadth of giga-project development, with its long-term success conditional on arm's-length governance, market-rate commercial hurdles, and institutionalized capital recycling. The paper contributes an integrated model connecting SWF mandate design, institutional governance, and domestic absorption capacity to sustainable transformation.