Heavy flavor production and interaction from hot to cold QCD

The PHENIX detector at RHIC recorded heavy-ion data for sixteen years, recently ending its run in 2016. PHENIX has since been fully dismantled, with the new sPHENIX detector currently completing installation in the same location at RHIC. sPHENIX, projected to come online this spring, and the STAR experiment are expected to continue collecting heavy-ion data through 2025. Although PHENIX is no longer actively recording data, the last three years of running collected data across several different collision systems: p+p, p+Al, d+Au, and Au+Au. Similarly, the LHCb experiment at the LHC can also record data across a wide range of collision systems with SMOG, a unique fixed-target system installed for Run 2. New heavy flavor measurements from the LHC, including the ALICE and CMS experiments, can help shed light on hot versus cold nuclear matter effects and can be helpful to compare to RHIC energies. With preparations for the upcoming Electron-Ion Collider already underway, a new era of physics lies on the horizon. Interest in ultra-peripheral collisions is growing within the community, and vector mesons provide a cornerstone of the upcoming EIC heavy-flavor physics program. Here we will present an experimental summary of heavy flavor results from LHC and RHIC from p-p to p-A to A-A collisions and the transition into the EIC Program.