A little confused about curseforge

I'm still not completely sure if I'm going to get curseforge, but there are a few things I want. (Veinminer, Biomes o` Plenty, Bliss Shaders) However, I'm hearing that you have to enter your microsoft account password to use mods, which is worrying. I also think I've heard that's only for modpacks, but I'm not sure. Would be nice to know.