This has been touched on in other threads, about other trades. It really depends on what type of environment you are most comfortable with or seeking, if you have a preference for a certain part of the country, etc.
I am personally biased towards opting for a posting at a base in or near a decent sized city. It gives you plenty to do and a chance to get away from the military in your off-time. (Victoria, Edmonton, Halifax, etc.)
There are a lot of really cool opportunities in the military police that a lot of people don’t know about. In addition to considering posting, you may want to dig into some of the cool opportunities the MP Branch has. (If you haven’t already.)
Good luck & welcome to the forum