Most major city downtown stores (such as Halifax) should have plenty of the product.

Going off of your example of Modern Warfare 2, we still had a lot left after the midnight launches. We won't get as many copies for Final Fantasy, but I'm willing to bet that as long as you go the first day, you'll get your hands on a copy.