if you need a good 'compromise' tire, you might look at Pirelli Cinturato . They helped us survive white-out conditions returning from Colorado a few years ago in winter storm 'Ursa' . They are not noisy and work well for us in downpours here in DFW area too.
But, if you absolutely must be able to drive in very bad snow conditions, the BEST all-season will never be as good in snow as the WORST dedicated snow tire.
tires are full of trade-offs and you must be honest with yourself about requirements - then comes your budget.
everyone wants a tire that's ; quiet, comfortable, gives great fuel economy, doesn't overheat at highway speeds, grips good when cold, great traction in rain, great grip in snow, long-lasting, and cheap...yeah, that's not gonna happen.