My partner's mom (Canadian) is a RN in southwestern Ontario, which is the part you'd most likely want to work in if you wanted to be close to Michigan (think Sarnia, London, Chatham-Kent, Windsor), unless you're looking to be closer to the upper peninsula, in which case you'd look at places near Sudbury/Sault Ste. Marie or Thunder Bay, which are large but relatively isolated communities in Ontario. She was one of the lucky few in her class 30ish years ago to get a position in a Canadian hospital-- most of her classmates went to the US. Nowadays they are not hiring RNs very often and instead hire nursing assistants since they are less expensive to employ but are "essentially the same" (we know they are not, but that's administration for you). Healthcare is very often under tight budget restraints. Because of this, getting a good position as an RN will be challenging for you, but I don't think it would be impossible.
As per scylla's comment, have a look into Ontario's licensing requirements (
I think these are them?) and see if immigration to Canada would even be feasible for you and your family.