Regarding sweat, I always sweat no matter how cold it is, so that isn't the issue. For me, proper rain gear is for keeping warming and reasonably dry. In hotter weather, eg 70 F or warmer, I am going to get about as wet from sweat as I would from the rain. However, in cooler temperatures, breathable rain gear works reasonably well to excellent, depending on the temperature. A lot also depends on level of exertion. If you hammering it, you are probably going to sweat a lot no matter what you are wearing. However, if I am riding at a moderate pace, I do not sweat much wearing my Showers Pass Elite jacket in cold, cool and mild temperatures.
For example, I rode the GAP-C&O Canal trails in May with several friends. We had one rainy day when it was misting to light drizzle during most of our 60-mile ride, with temperatures in 60s F most of the day. I wore my SP jacket the entire day and was very comfortable. I wore a simple long-sleeve wicking synthetic shirt under the jacket and did not sweat very much. The jacket kept me warm and reasonably dry. We were also riding at a moderate 12 mph pace due to the trail condition and the loads we were carrying.
In the winter, I am comfortable wearing the SP jacket with a single long-sleeve wicking shirt underneath in temperatures down to about 20 F, and I add an extra layer for colder temps.
If you shop around on-line, you should be able to buy SP Elite jackets for much less than retail. Eg, Biketiresdirect.com often has them on sale for about $175 and REI sometimes does as well.