Do SRD 5e spells properly trigger active effects?

So I'm a new Foundry user and I've noticed some spells, like Charm Person, work great and will prompt you in chat to apply an active status. Other spells though, like See Invisibility, don't actually do anything. I thought this was especially weird because they advertise see invisibility as a feature in their 2023 overview video (link). Any tips, or am i doing something wrong?