What are people getting these days on buying with great credit?

In Ontario curious as I sold two years ago and have been renting. Looking at buying we have A+ credit little debt and 250k down looking to purchase around the 1M mark. This would be 3rd house, I don’t think I want to go over the 1M and pay CMHC if I can help it. Assuming with the current fragile economic conditions probably best for variable short term? But curious what a great 5yr fix?