The RX 580 is old, hot, and uses a lot of power. Definitely do not get the 580.
The 1650 super is efficient and of good value. I'd get a 1650 super.
The cooling ability of a GPU depends on what model you purchase. Different models have different cooling systems. Figure out which GPU you want to get, and then read reviews about he different versions to find out which ones have good cooling systems.