I'm been working in the US for the past 4 years. I don't have a degree, but I had close to 10 years of industry experience when I mode here.
1. For someone without a CS degree, how much experience does it take to be attractive as a foreign hire to a US company?
You don't need any experience to be attractive to employers, provided that you can demonstrate the right skill level, but you will need quite a bit in order to convince the USCIS to issue you a work visa. Probably at least 5, this stuff must be documented somewhere; do your research.
2. How complicated is the process of getting a visa and moving there in terms of processing time, papers, finding a place to live etc?
This stuff is trivial for Canadians on a TN visa, just a bit harder for H1B. Your future employer will help you with everything.
3. How bad is the healthcare situation? I hear insurance plans cost an arm and you're still left with a 10/15k deductible for every year, is that right?
Your future employer will most certainly cover everything. If you are covered, healthcare service is really good in the US.
4. How complicated/expensive is it to have a child born there?
???
5. How much better (or worse) is the after tax & expenses income? Are you earning more and saving more than you were at a comparable job in Canada?
Tax is very comparable to Canada, but many parts of the US will pay way more for software developers, so you win by moving south.
6. How different is the culture (working hours, remote working, PTO) compared to Canada?
Just like in Canada, this varies a lot from one company to the other. Don't believe anyone who makes broad generalization and inquire about the culture at the companies you are targeting.
7. Did you have to go through a recruiter and lawyer or did your employe take care of everything?
I left my new employer take care of all the relocation and immigration problems. It really was a no brainer.
8. Last but not least: would you recommend doing it?
Yes! Given how strong the US dollar is compared to the loonie and how easy it is to go back if you don't like it, you have absolutely nothing to lose.