Both my 3090s have heat problems. I would avoid the 3090 and 4090.

Get a 3080ti or 3060 with 12gb of ram. If you want to experiment with very high memory models then pay for colab pro.