The major difference between the MSF and MBA is the curriculum. MBA curriculum will have some finance, but will also cover marketing, operations, management and organizational leadership, decision-making with data, etc. All of the MSF programs that I've seen heavily overlap the CFA curriculum, so you would be learning a lot of material that you probably already know (e.g., financial statement analysis, economics, accounting principles, derivatives, equity and fixed income products, etc.)
I'm not familiar with MSF/MBA programs in Canada or Singapore, but I do recommend that you avoid part-time or online programs, as these programs often lack on-campus recruiting, which is the best chance of securing a great job after graduation. Your decision would be a lot easier if you focused on what country you would be able to or want to live and work in for the next 1-2 years. From there, it would be easier to find the right program.
Will having CFA level 2 compensate for your GMAT score? No. Will it help your overall application? Yes, but keep in mind that most MSF applicants have passed one or more levels of the CFA program. In order of importance, your GMAT score is second, GPA is third, and CFA progress is fourth. The most important part of your application is going to be your "story", which will come out in the essay and interview (if the program requires one). Why did you leave your role at Infosys to become a financial advisor? Why do you want/need a Master's degree and why do you want/need it from this particular program? If you have a great "story", that will make up for the lower GMAT score.
If you're certain about the MSF, I would check out this page:
https://www.wallstreetoasis.com/forums/comprehensive-us-msf-ranking.
Focus on the Tier 1A and 1B programs. The rest are not a good return on your investment.
Wherever you decide to go, I wouldn't apply this year. Most of the deadlines have already passed and you need time to craft your story, get strong letters of recommendation, etc. If you're up for it, give the GMAT once last shot. Just focus on verbal and aim for a 680+. Getting into a sport or community service would really help too. These programs aren't looking for geniuses with top GPA's and 780+ GMAT scores. They want
smart, interesting, well-rounded applicants.
Best of luck to you.