My personal favourites for hot, steamy days are usually on the dry, and non-sweet side and often contain elements of citrus, vetiver, leather and clear florals so my style may not be to your taste.
Reviews suggest that Tresor Midnight Rose is quite sweet with strong berry notes and I also see that you have a few rose fragrances in your collection.
With that in mind, two designer scents that might work for you are "Paul Smith Rose" and Bvlgari "Rose Essentielle". The latter is a pretty rose with a blackberry note and although it leans a bit "girly" for my taste, it's a versatile scent that works in hot weather and is one of the few fragrances I have received compliments on (at yoga class, of all places).
Two niche scents that come to mind:
Andy Tauer's "No. 10 - Une Rose Vermeille" - a fruity (orange) rose, very long lasting. It didn't work for me but has many fans and might appeal to you.
Serge Lutens "Nuit de Cellophane" is a long-lasting fruity floral that has a clean, shampoo-like vibe. It is quite a fun fragrance that is not too heavy for hot weather. It smells more designer than niche but can be found at online discounters.
Lastly, you could also check out the link (below) that has summer suggestions from Parfumo members, particularly citrus/floral combinations.www.parfumo.net/forum/viewtopic.php?t=1076