If you want a 10GBASE-T SFP+ module that doesn't run hot, look for one with 802.3bz support. Any module that supports 2.5G and 5G speeds has newer silicon which runs cooler.

There is an old but still good list of transceivers with this feature here: https://www.servethehome.com/sfp-to-10gbase-t-adapter-module...