I think it was two nights I stayed, when I went, around 11 years ago. It was pretty much what you'd expect out of a very quaint maritime island town, with European/French influence. Everything was in Euros, French language, culturally French (in contrast to Quebecois French). A little bit more English because of the tourism aspect. Very rainy and dreary on the day I arrived (the pontoon boat ride over was also quite rough; be wary if you're easily seasick). Next day was gorgeous, and we did a bus tour around the island, tour gide talked a little bit about the geography and history of the island(s). IIRC Miquelon is very sparsely populated so it's mostly just St. Pierre.
Nothing life changing, but worth visiting if you're close enough I'd say
BC is gorgeous, no matter the weather, but it can get crazy.
AB is a tale of two opposites, in more than one way.
SK, and MB, can be very boring, but also gorgeous -- being able to see isolated storms way off in the distance, or the sunset of a million yellows and oranges and purples for what feels like days, over a field of canola, can be a quiet gratitude.
Northern Ontario is gorgeous in a way that it doesn't have to compete with BC's mountains. The Canadian shield is... well, it's Canadian. Southern Ontario, and Quebec, along the main corridor, are boring and full of people.
I don't know much about the rest of Quebec, and I haven't spent a lot of time in the Maritimes (with the exception of Newfoundland).
Newfoundland is distinct. The people have a history (and they're super kind), they have all sorts of geography and historical quirks. The weather is tough, and it's really shaped the people, it really is quite a rock they live on.
If you love nature, I highly highly highly recommend you drive through some or all of the sections, if you get a chance. All of them, even the supposedly boring SK/MB stretch. It took a long time, but I really do appreciate it now that I've moved away.