with your trusty tripod you can try 1730 to 1800 onwards thats a good time with nice lighting... maybe you need to worry long shadows coverign your subject of interest that can be quite frustrating haha.
depends what you are shooting ..... scenery of course early morning or before dusk.
if you are going to consider the heat, of course I will prefer 7.30am to 11.00pm, and 4pm to 7pm. However still depending where is the location. I took pictures at Botanical Garden in the morning, I still need to push my ASA/ISO to around 400 - 800. Even at the Zoo, sometimes up to 1600. Due to the tree shade!!!
Therefore it takes many factors to consider....... depends on what you want
Think that there is a price for good shots ... well, if we think that noon is a good time, then be prepared to sweat it out a bit under the hot sun to get the shot lor ... I like noon time for the saturation of the colours ... I like night time long-exposures shots, I also like dawn and dusk time for the colours of the sky ... every time of the day provides opportunity for a good shot