Canadian here who worked in the Valley for ~7 years, and currently works for a US-based startup remotely.
You're absolutely right that the culture of respecting changemakers is not as present in Canada. But the SFBA is the world leader here. There probably isn't any place on earth that's more optimistic about innovators.
I don't think this is a culture thing, exactly. It's just that everyone who became rich in the SFBA did so by exploiting trends or innovating – since like, the 1890s. And the USA plowed zillions of dollars into the tech ecosystem in the Bay Area since World War II. Once you have that tech investor class, culture bends a lot towards their way of thinking.
Investors in Canada just don't have that kind of money to play with. Or, they made their money in an old-school industry, like resource extraction, and they flip out at the risk levels in tech startups.
In terms of prevailing national norms, I'd say Canada is slightly more change-friendly than the USA. Think about all the ways that the USA tries to kill immigration, stifle innovation in favor of incumbents, and put regulatory barriers in the way for entrepreneurs.
In contrast, Canada has lots of official policies to support tech entrepreneurship and skilled immigration. Plus, socialized medicine really does make it easier to be an entrepreneur. Politically and culturally, Canada isn't that into retro stuff, or trying to revive earlier, more conservative eras. People think their best days are ahead of them.
It's true that the people in Canada are not super interested in overturning anyone's applecart, for its own sake or just to get rich. That's not as respected here. People are more likely to be interested in innovations that improve the general social welfare. But maybe that's not such a bad thing.