I've seen some of the more level headed normie Americans on normie sites try to reassure normie Canadians that it's very, very unlikely that the president would actually order an attack on Canada. Also that if that were to somehow happen, most Americans would flatly refuse to participate in such idiocy. I think that's true. I'd also refuse and I can't imagine an American who would be willing. Americans rarely think of Canada at all, but when we do we usually see Canadians as our slightly goofy, sometimes annoying liberal cousins. No one wants to massacre their goofy cousins for being liberal and annoying.The Liberals are pretty much doing whatever they want at this point. The media is running point for them, filling the 24hr news cycle with OrangeManBad/tariffs/Ukraine so all the normies are in a lather.
The normie Canadians have beem responding that Trump has been purging the US military and installing loyalist commanders who absolutely would follow through on an order to attack Canada. This seems like made up hysteria to me, but who knows. Also, although I said I can't imagine anyone in the USA really being willing to participate in an attack on Canada, on the other hand look at all the people who went along with the COVID craziness hook, line, and sinker.
I'd still say War of 1812 part Deux is very, very unlikely but with all the bizarre things that have happened in the last 10 years, I can't say I'm 100% convinced it's impossible.