Coherent and dissipative cavity magnonics