Physics is living an era of unprecedented cross-fertilization among the different areas of science. In this perspective review, we discuss the manifold impact that state-of-the-art cold and ultracold-atomic platforms can have in fundamental and applied science through the development of platforms for quantum simulation, computation, metrology and sensing. We illustrate how the engineering of table-top experiments with atom technologies is engendering applications to understand problems in condensed matter and fundamental physics, cosmology and astrophysics, unveil foundational aspects of quantum mechanics, and advance quantum chemistry and the emerging field of quantum biology. In this journey, we take the perspective of two main approaches, i.e., creating quantum analogues and building quantum simulators, highlighting that independently of the ultimate goal of a universal quantum computer to be met, the remarkable transformative effects of these achievements remain unchanged. We wish to convey three main messages. First, this atom-based quantum technology enterprise is signing a new era in the way quantum technologies are used for fundamental science, even beyond the advancement of knowledge, which is characterised by truly cross-disciplinary research, extended interplay between theoretical and experimental thinking, and intersectoral approach. Second, quantum many-body physics is unavoidably taking center stage in frontier’s science. Third, quantum science and technology progress will have capillary impact on society, meaning this effect is not confined to isolated or highly specialized areas of knowledge, but is expected to reach and have a pervasive influence on a broad range of society aspects: while this happens, the adoption of a responsible research and innovation approach to quantum technologies is mandatory, to accompany citizens in building awareness and future scaffolding. Following on all the above reflections, this perspective review is thus aimed at scientists active or interested in interdisciplinary research, providing the reader with an overview of the current status of these wide fields of research where cold and ultracold-atomic platforms play a vital role in their description and simulation.