I used a bit of deductive reasoning and concluded that both Better Bodies and the MCP Showcase were you only mods installed with an exe, and the rest were extracted with 7zip or with the default windows file extractor. I went to the Morrowind directory in 7zip and when I entered Data Files all of the esps were showing.
So, basically almost all of my Morrowind esps are working properly, but are somehow invisible in my Data Files directory. I know it isn't really a huge issue, but I'm a bit OCD and I'm really hoping someone can explain this.
Edit: Might as well toss in some pictures in case I didn't explain the issue well.
Data Files in 7zip: http://i.imgur.com/TLOQy.png
Mods Show up in Mash: http://i.imgur.com/9K9OW.png
But almost all added mods/folders don't appear in Windows Explorer: http://i.imgur.com/jTMB8.png
Edit: One more quick update, it seems like this isn't exclusive to just Data Files, I checked to see if any other files were missing in the Morrowind directory and a few other extracted things likes readmes aren't appearing there either.