Canadians certainly have differing opinions on politics however it's definitely a tiny minority that share your opinion on being happy if Canada became part of the USA.
It's all quite preposterous because many Canadians would probably have been fine in the past with some kind of currency union and trade and enhanced labour mobility if such a thing had been proposed during e.g. the Obama years.
At that point our currencies were often at par, the two governments were generally very friendly, and trade was going rather well. Canadians would probably welcome increased competition and services domestically.
Since then the US has become successively more dysfunctional. And while we have had our own issues and things have become problematic here in many ways (cough cough housing prices cough cough), the kind of insane disgusting culture war going on in the US is not something the majority has an appetite for.
In any case a full political union where Canada is absorbed makes no sense, it's so radically out there... the two political cultures are so far apart... and especially a "proposal" that reduces an entire continent spanning country with 3 oceans, 41 million people, two official languages... to a single US state. It's preposterous and inflammatory. "51st state" is not a serious idea, but it's become an idiotic battering ram destroying all civil discourse.
