Of course you aren't going to enjoy it as much as when you got your first raid tier set, you likely didn't enjoy the rest of them as much either. That's an unrealistic expectation to hold transmog gear to, as by it's very nature it's all about the look as opposed to the stats and status.
New gear, especially mythic raid gear, still has the status, stats and unique looks that it has always had and it still loses it's power like it always had. Even in pre-transmog times there were raid sets that were jokes, as you said early you were a wrath raider and a rogue so you probably heard the jokes about the rogue Ulduar set.
If your class got a cool tier set you got to look cool for a raid tier, but if you got a bad one you looked like a joke for 6 months. For example I played a priest in Cataclysm so my tier set was the Mercurial Regalia, which had obnoxious shoulder effects on giants shoulders that made me look like a walking fountain and Regalia of the Cleansing Flame which was called a toilet regularly. I personally liked the latter, but the point still stands despite walking around in tier gear rarely was the impression that I looked cool, instead the impression was that I looked silly.
Ironically I took to changing out of tier gear to look cool via proto transmog runs, something that was made much simpler once the system was implemented.