I think you're missing the point of this entire conversation. This isn't an argument because music is entirely down to personal taste. What could I possibly say to convince you that the Yanxia theme was written by Satan to torture mortals? If it doesn't bother you, then it doesn't bother you.
The only thing I came in here to figure out was if my tastes are really just *that* different from the FFXIV fanbase, if I just haven't gotten to the good stuff yet, or if people just tend to forget the map/cutscene music once they've been farming mounts for more hours than they spent on the MSQ originally. From what I can see, it seems that most of the soundtrack really is that forgettable because the only songs people talk about are boss themes and final cutscenes/credit rolls. I see some sparse mentions of map themes here and there, but overall my suspicions about the uptick in quality post Stormblood as well as the concentration of quality in boss themes seems to have been right.
The only place where my opinion seems to greatly differ with people is that not that many people seem to have individual songs that really annoyed them. For me, Safety in Numbers from Heavensward, Othard Camp and Yanxia Theme (Day) from Stormblood (had to look up the names because it was taking too long to describe them each time) are bad enough that I actively avoid going to those areas if I can (which I couldn't any time the MSQ took me there. At the very least I would never ever AFK there and would always leave before opening the menu to look at something or sort my inventory, etc). I've never played another videogame before where I purposefully avoided an in-game area because the music actively irritated me.
And just to throw you some more bones, I really liked the map themes from the sky islands from Heavensward (Cloud Sea I think?) and all the Coerthas music and the Heavensward credits theme was absolutely amazing. I also like the Kugane theme (the second half, not the first half), and I actually really love the dungeon boss theme in Stormblood. I don't really remember any of the trial themes off the top of my head except for Shiva's where I distinctly remember thinking "holy shit" when she uses diamond dust, the whole arena freezes over, and then this electric guitar kicks in. I sat up in my chair real quick at that point.
I'm not some prude who insists that music not composed the "same way as classical music is" is "not good music." You'd know that if you actually read my entire comment though, specifically where I said I thought the trials music was really good. That's my problem with this community in a nutshell, though. You guys get so f***ing defensive any time someone doesn't think the game is a 10/10 experience. Like just chill dude. Fastest way to convince someone not to play your favorite game is if you purposefully ignore what they're saying and argue against a strawman instead. Doesn't really matter though since I'm gonna keep playing anyways.