If you use something like MSFS Addons Linker that creates Symlinks of your contents in the Community Folder you can have subfolders in the actual location that you stire the mods.
So while the Community folder may be a bit of a mess the actual folders you work with can be as well organised as you like.