The mod has BY FAR the best presentation and time put into it than any other Hoi4 mod.
The narrative and lore is terrible, but the plot is presented very well and you can tell that whoever writes this knows a whole bunch about literature and how to write. It's like a Picasso painting - it's very weird and many will dislike it, but you can respect the effort and talent of the artist, even if it was misguided.
And unlike most Hoi4 mods (including Vanilla Hoi4), the campaign is huge and many countries can take 15-20 ingame years to finish its storyline (meanwhile, in Vanilla Hoi4, it is terrible to play the game past 1944)
I don't need to tell you why this mod is bad, because there is a 200+ pages thread about it, but hopefully you can see why so many people are invested/interested in it
TL;DR: Presentation and scope
I have hopes for TNO Redux.
Honestly TNO fucking sucks, its way too linear and could have been so much more. I played through the game a thousand times before giving up, my most memorable playthrough was Samara where I caved in communist reunifier skulls and had to console command my way to take down germany, surprisingly they didn't launch nukes and I actually managed to get a peace deal conference, but my game crashed after that.
No puppeting, No potential Eastern/Western bloc paths, No focuses for low nations. Booooring.
As well as the fact that I encountered dozens of bugs hindering progress towards reunification such as nations not returning under my control, Iran and Norway not joining the war despite them being in the Einheitspakt, as well as the fact that heaps of shit in the game are just unrealistic, like a communist guerilla force in vietnam somehow managing to gain their independence from a Japanese empire spanning all across asia, running a corporate hegemony over their puppet states, and also has the ability to put down a chinese nationalist revolution with ease, but Ho Chi Minh will live another day.
An Honorable mention to other unrealistic shit in TNO is the Aryan Brotherhood, because there would totally be an ethnic group dedicated to self destruction in the name of "ethnic purity" and "aryanism", the fact that National Socialists are depicted as generic dictatorships whereas Ultranationalists are depicted as super duper hyper ultra kaizo nationalists who defend their lands and people to the dying breath, and the fact that India has no content whatsoever.
If you really want a good cold war mod, play the Cold War Iron Curtain mod or TWR, because at least TWR has a functioning Deutsches Sozialistische Republik path on day one.