Any modern gun is basically reliable. As gwhysow said, go to a gun shop and handle as many as you can. Where are you in Alberta? Edmonton, Red Deer and Calgary have some pretty nice stores. There are also some knowledgeable CGNers from Alberta.
Asking about any gun without being specific is like asking what car you should buy or what should you order at the restaurant.
The M9 or 92F/S you mentioned is an excellent gun. But it has a wide grip, you can’t change the front sight easily and I personally don’t like slide mounted safeties.
For metal hammer guns, I would recommend looking at the Beretta you mentioned, the CZ-75 series, the SIG P - family and even the 1911 or Browning HiPower.
For polymer hammer fired guns, I would look at the USP.
For polymer striker fired guns....the worlds your limit! Any modern one works well. Find one in your price range and looks good to you.