Not really ideas, just logic. You're already putting conditions for when the blinds should activate. Find a good weather sensor for your home that tells you precisely the weather in your area and for each condition (sunny, rainy, cloudy) set the blind to a position.
A tip I can give you is to try running this automation often, because "cloudy" can start today and end in 3 days, but the sun will affect the perceived light too. A trigger that runs hourly, with the condition that you listed, could be a starting point.
This is a particularly complex automation if you have to manage all the cases.
I personally have them set to open in the morning and close at evening. But, if the morning is > 26 deg. Do not open them, because it'll be too hot. If during the day it goes below 26 then open, same if it goes above 26 during the day == close.
Cloudy, rainy or other conditions, I do not check them because I generally like them open during the day.