I don’t think I’d drive an SUV at all if you were concerned with cost or handling, but IMO it depends on what you need: Modern traction control with good all terrain tires can handle extremely well in snow or rain - AWD isn’t necessary.
That said, my current daily driver is an AWD manual Subaru sedan and I have to admit: It corners better and is just a bit more resistant to losing control and a little faster in regaining control. If cost is not a concern, go with an AWD sedan especially if you drive in adverse conditions a lot.
If money is tight, stick with your FWD sedan and make sure you have quality all season tires as well as keeping your brakes and related systems in good condition - this would likely be more than adequate in any reasonable conditions especially if you are already a good driver (and if not, it’s never too late to learn).