Clustered regularly interspaced short palindromic repeats (CRISPR)-based genome editing is evolving into an essential tool in the field of biological and medical research. Notably, the development of catalytically deactivated Cas9 (dCas9) enzyme has substantially broadened its traditional boundaries in gene editing or perturbation. The conjugation of dCas9 with various molecular effectors allows precise control over transcriptional processes, epigenetic modifications, visualization of chromosomal dynamics, and several other applications. This expanded repertoire of CRISPR-Cas9 applications has emerged as an invaluable molecular tool kit that empowers researchers to comprehensively interrogate and gain insights into health and diseases. This review delves into the advancements in Cas9 protein engineering, specifically on the generation of various dCas9 tools that have significantly enhanced the CRISPR-based technology capability and versatility. We subsequently discuss the multifaceted applications of dCas9, especially in interrogating the regulation and function of genes that involve in supporting cancer pathogenesis. In addition, we also delineate the designing and utilization of dCas9-based tools as well as highlighting its current constraints and transformative potentials in cancer research.