Macrophages not only represent an integral part of innate immunity but also critically contribute to tissue and organ homeostasis. Moreover, disease progression is accompanied by macrophage accumulation in many cancer types and is often associated with poor prognosis and therapy resistance. Given their critical role in modulating tumor immunity in primary and metastatic brain cancers, macrophages are emerging as promising therapeutic targets. Different types of macrophages infiltrate brain cancers, including (i) CNS resident macrophages that comprise microglia (TAM-MG) as well as border-associated macrophages and (ii) monocyte-derived macrophages (TAM-MDM) that are recruited from the periphery. Controversy remained about their disease-associated functions since classical approaches did not reliably distinguish between macrophage subpopulations. Recent conceptual and technological advances, such as large-scale omic approaches, provided new insight into molecular profiles of TAMs based on their cellular origin. In this review, we summarize insight from recent studies highlighting similarities and differences of TAM-MG and TAM-MDM at the molecular level. We will focus on data obtained from RNA sequencing and mass cytometry approaches. Together, this knowledge significantly contributes to our understanding of transcriptional and translational programs that define disease-associated TAM functions. Cross-species meta-analyses will further help to evaluate the translational significance of preclinical findings as part of the effort to identify candidates for macrophage-targeted therapy against brain metastasis.