James – As Alex says uncooled cameras like DSLRs or mirrorless cameras can do a very good job for generally less money than a cooled camera. Modern CMOS sensors are very low noise even at room temperature. Here is an image of the comet taken with a Sony A7s:
https://britastro.org/observations/observation.php?id=20241020_080600_25df8a3cd03b0737
I think a lot comes down to good processing rather than cooled or uncooled sensors.