Sirtuin 6 (SIRT6) is a NAD+-dependent nuclear deacylase and mono-ADP-ribosylase with a wide spectrum of substrates. Through its pleiotropic activities, SIRT6 modulates either directly or indirectly key processes linked to cell fate determination and oncogenesis such as DNA damage repair, metabolic homeostasis, and apoptosis. SIRT6 regulates the expression and activity of both pro-apoptotic (e.g., Bax) and anti-apoptotic factors (e.g., Bcl-2, survivin) in a context-depending manner. Mounting evidence points towards a double-faced involvement of SIRT6 in tumor onset and progression since the block or induction of apoptosis lead to opposite outcomes in cancer. Here, we discuss the features and roles of SIRT6 in the regulation of cell death and cancer, also focusing on recently discovered small molecule modulators that can be used as chemical probes to shed further light on SIRT6 cancer biology and proposed as potential new generation anticancer therapeutics.