There is only one Community folder. Now that you have found out which one the game is reading you can cut-paste all mods into D:/Users/Community & get rid of the others.
As a test you can move just ONE mod into D:/Users/Community. Preferably a plane - which will appear in the aircraft selection menu. This way you’ll know instantly which folder is being read.
After that just dump all mods into D:/Users/Community
Side note: if you delete the Community folder that the game DOES use then MSFS will simply make another one during next startup.
In case you’re not familiar - I highly recommend the excellent Addons Linker software (free) which uses Symbolic Links and lets you keep your mods anywhere. It makes Windows “think” they are in Community when they aren’t. This leaves you free to place them anywhere.