The best sound you can get on trumpets will come from a decent ribbon mic.
The MD421 is pretty hot sounding, the 421 MKII a little hotter than the MKI.
The MD441 is absolutely great on trumpets and bones, as well on saxophone.
The SM57 is decent, the SM7 a whole lot better.
Some LDC's can sound quite good on trumpet, like the MXL V77, the SP B1 is not nice on trumpet (IMHO that is).
The Beyer M201 is quite good on trumpets too, the M69 and M88 much too bright.
But if you want a warm and fat trumpet sound: ribbon.