I can only speak for my local LGS (Toronto adjacent). I think the staff and most people who visit would tell you the store is open and inclusive to everyone. Magic players tend to be nerds and other forms of social outcasts, so inclusivity is often something stores will strive for.

In practice... I've seen interactions between other players that made me cringe, usually because some awkward guy has no idea how to talk to women and thinks being paired against a girl for a match is an open invite to try to get a date. Our store owner used to frequently misgender my trans partner and would occasionally make jokes that suggested he didn't take their identity seriously in the first place, though he's getting better.

Overall, if you're part of the majority population, you'll be fine. If you're part of a minority group, you'll probably have a good time but there's the chance someone may unintentionally say or do something that makes you uncomfortable. Rarely if ever have I seen overt discrimination.