The weather can never be guaranteed.
We went at precisely that time of year and had a great trip.
I'm 99% sure The Maid of the Mist etc I doesn't run so if you want all of that then that isn't the time to go.
To me it is a pointless attraction that just makes you wet. We saw Niagara Falls from the viewing areas and got wet enough with that!
We drove ourselves everywhere and yes there IS snow and ice around.
The main roads are kept clear really well with salt etc. Smaller roads not so much but they are still pretty good.
Given you don't seem to like driving generally I probably couldn't advise this to you. We have quite a bit of experience driving in Snow etc and I believe it is worth putting up with. But this depends how far you are planning to go.
The cars you hire are fitted with snow tyres and there is none of this "take chains" crap that happens in Australia.
Montreal was the worst weather when we were there because it went down to -30 wind chill which isn't fun.
BUT...it was absolutely beautiful as I just adore winter and things covered in snow
In short I think it is fine, but depends on you...