BCG, a first-generation live vaccine, is being reconsidered as an immunological platform. Interest in its heterologous protection intensified during the pandemic. However, large-scale clinical trials revealed inconsistencies in the efficacy of native BCG. This review argues that BCG's main value lies in its potential as a modifiable vector platform and in its ability to reveal tractable molecular pathways for therapeutic design. This review summarizes the molecular basis of BCG-induced trained immunity (TRIM), focusing on PRR-driven signaling, metabolic rewiring, and epigenetic remodeling in innate immune cells and hematopoietic progenitors. It also maps their convergence with pathways that sustain pro-tumorigenic inflammation. The original conceptual paradigm of the "TRIM-Cancer Paradox" is presented. This paradigm posits that the same innate immune circuits that mediate protective heterologous responses can drive tumor-promoting inflammation and immune escape under conditions of chronic dysregulation. Recombinant BCG (rBCG) is further analyzed as a strategy to rationally amplify or redirect these circuits, the current clinical landscape of BCG-based interventions across various diseases and oncological malignancies is highlighted, and specific molecular nodes that could be exploited to increase the precision, efficacy, and safety of rBCG-based therapies are identified. Overall, this review proposes BCG a programmable immunological platform and to use the TRIM-Cancer Paradox as a novel design principle for next-generation rBCG platforms that transcend traditional vaccinology and cancer immunotherapy applications.