Surface-enhanced Raman scattering (SERS) stands out as a highly effective molecular identification technique, renowned for its exceptional sensitivity, specificity, and non-destructive nature. It has become a main technology in various sectors, including biological detection and imaging, environmental monitoring, and food safety. With the development of material science and the expansion of application fields, SERS substrate materials have also undergone significant changes: from precious metals to semiconductors, from single crystals to composite particles, from rigid to flexible substrates, and from two-dimensional to three-dimensional structures. This report delves into the advancements of the three latest types of SERS substrates: colloidal, chip-based, and tip-enhanced Raman spectroscopy. It explores the design principles, distinctive functionalities, and factors that influence SERS signal enhancement within various SERS-active nanomaterials. Furthermore, it provides an outlook on the future challenges and trends in the field. The insights presented are expected to aid researchers in the development and fabrication of SERS substrates that are not only more efficient but also more cost-effective. This progress is crucial for the multifunctionalization of SERS substrates and for their successful implementation in real-world applications.