It partly depends on where you are. Much like the US, there's a split between urban and rural.
I can only really speak for Toronto. We have a center-left mayor, fly the progress flag at municipal buildings, have strong LGBTQ protections, and have a generally welcoming population. The biggest issues with trans health care are due to the systematic destruction of our health system by a conservative grifter with a personal vendetta against us, and the federal government (useless libs) is just letting him do his thing. Mind you, that's a problem province-wide. But otherwise, I feel very safe here
Ottawa seems quite queer friendly from the times I've visited. The rainbow flag is flown loud and proud. I also used to work in Kitchener/Waterloo but rarely left the office (I'm a big city girl so it's not my vibe), but my friends out there seem to like it. I also have trans friends in Guelph. Hamilton recently struck down a transphobic train ad, which is a good sign.
Doug Ford can go fuck himself with a rusty tailpipe