1-No this is just a provincial offences ticket so it will not show up in a criminal records back ground check.
2-This depends on what law you were charged under. If you were charged under a municipal by-law then the record will be cleared as soon as you pay the fine. If you were charged under the Highway Traffic Act, it would be on your publicly available driving record for 3 years, same as any traffic violation.
3-No, the US only cares about criminal offences. Since this is not a criminal offence it will not harm your ability to cross the border. If they banned every person who ever got a provincial offences ticket most drivers would not be able to cross the border as most people who have been driving for awhile have had at least one ticket.
4-No, this will have very little impact on getting a job. It will not show in a standard criminal record check. The only place it might show would be on your driving record which many employers don't bother checking. Even the ones that do check driving records don't tend to be too bothered by one minor violation. They are really just checking to make sure you are not a maniac behind the wheal.
5-No it is a minor violation.
6-This will depend again on which law you were charged under. If it was a municipal bylaw then it will not appear on your driving record and so there would be no insurance implications. If you were charged under the Highway Traffic act then it is possible their might be an insurance increase. However many insurance companies forgive one minor offence every three years. Unfortunately each insurance company's policy is different so you would have to check with the company to know for sure.