The stimulator of interferon genes (STING) serves as a pivotal signaling hub in innate immunity, orchestrating type I interferon (IFN-I) and pro-inflammatory responses upon detection of cytosolic DNA. While the canonical cyclic GMP-AMP synthase (cGAS)-STING axis has been extensively studied in host defense and sterile inflammation, increasing evidence indicates that STING can also be activated through a variety of both pattern recognition receptors (PRRs)-dependent and PRRs-independent mechanisms. In this review, we comprehensively summarize the molecular pathways through which PRRs—including cGAS, interferon gamma inducible protein 16 (IFI16), DEAD-box helicase 41 (DDX41), and DNA-dependent protein kinase (DNA-PK)—engage and regulate STING activation. Beyond PRRs-triggered pathways, we explore emerging evidence of PRRs-independent STING activation, driven by genetic mutations, endoplasmic reticulum (ER) stress, dysregulated intracellular trafficking, and impaired protein degradation. These mechanisms contribute to the pathogenesis of a broad spectrum of inflammatory and autoimmune disorders affecting multiple organ systems, including the digestive, cardiovascular, renal, pulmonary, and nervous systems. We also highlight the current landscape of pharmacological inhibitors targeting cGAS and STING, categorized according to their mechanisms of action and therapeutic potential. The redundancy and complexity of components within the STING signaling network present challenges in effectively suppressing inflammatory overactivation by targeting a single molecule. Nevertheless, the central role of STING offers multiple opportunities for therapeutic intervention, whether by modulating upstream or downstream signaling elements. This review not only provides a systematic framework for understanding the intricacies of STING signaling, but offers insights into the development of next-generation therapeutics aimed at selectively modulating STING activity in disease contexts.