I have played a fair bit of EaW, because I had heard it is quite cool if you can get past the pony shit. Barrad being an actual ass text adventure with a magic dueling system was a sick surprise, the River federation is a really cool way to make peacetime interesting in an otherwise barren part of the world content wise, and the Posada path for Hippogriffia is pretty fun all around. I won't go so far as to have it be my main mod of choice, it's still a pony mod, but frankly if you're looking for an entirely new world, unique nations, and a shitload of new and actually useful technology to play around with, EaW is the gold standard.
Here's hoping as the fallout of the TNO clusterfuck continues to settle, and hoi4 modding will go back to being about the gameplay instead of about "muh ideology best" wanking. The community had a certain level of that from the beginning, there's no fixing it completely, but TNO and it's consequences have been disastrous for the HoI4 modding scene. There are mods with potential, I've mentioned Pax Britannica, Age of Imperialism looks interesting, and Thousand Week Reich is essentially TNO but with actual gameplay. TWR is quite jank at present, I think they're 2 DLC cycles behind in properly integrating the content from those DLC, but it has the potential to showcase an alternate history 50s cold war gone hot, with tactical nuclear weapons being used with reckless abandon, and the very beginning of modern combined arms warfare clashing with the last dying breaths of outmoded ideas (heavy tanks, massed infantry formations, etc etc)