New perspectives on neutron star and black hole spectroscopy and dynamic tides