Here are a few points:
1. You need to believe whereever you choose to live is the best place for you. If you don't think so, leave that place.
2. Always go to the place you think is the best. If you really think US is the best for you, go for it. 7 years ago I thought US was best for me, so I went to US. You will have better judgement of living place when you have comparasion.
3. Don't listen to other people's arguing. Although they are telling their true feeling, they are not you. You are the only person can make decision for you.
4. Since you are going to San Jose, the case is a little easier. Since you don't care 美国身份, the best case for you is your employer will do H1B for you so you can work in US up to 6 years, at the same time you hire a lawyer to do GC. The second best case is that you will be laid off within 6 months (very possible in San Jose) so you can be back to Canada safely. Anything else will put you in big trouble. Evaluate yourself to see whether worth the risk.