My go to autumn/winter rainwear is either one of the better jackets from Decathlon, from their Van Rysel brand of budget premium stuff which is very well sized and tailored, or the Castelli Perfetto ROS which is made out of somewhat better materials but while width and tightness is perfect I wish it extended a bit further down. That said neither is completely waterproof. If it is really pouring and really cold I add a packable rain jacket over all of it. As long as I dress that I'm cold at the start of the ride, the sweating isn't a big issue.
If it's really warm and raining I just don't care and wear summer kit with maybe a water resistant gilet and simply get wet 🤷 There's no winning move to stay dry when it's both warm and raining.
Castelli have also made some sort of Shakedry based packable rain jacket but it's obscenely expensive even for my tastes.