Now that we’ve fated all 3 raids, is Nathria still the best raid of SL?

No. It's the worst of the three on mythic, by a long way. It's got a neat aesthetic and I'm sure that's why it's popular here, but the majority of the raid is atrocious on mythic. Shrieking, huntsman, hungering, and inerva are boring; sun king, council, and SLG are actively awful; sire is fun in p2 and p3 but p1 is a ludicrous lagfest that lasts too long. Xymox and sludge are fun, but that doesn't make a whole raid.

Meanwhile, tarragrue is arguably the best intro raid boss ever, the eye was extremely interesting for a second mythic raid boss, remnant, painsmith, and soulrender we're fantastic mid bosses. Sure, sylv was a slog and guardian, KT, and fate were let downs, but fate is the only actively bad fight in Sanctum, with Lords and Pantheon as the only actively bad fights in Sepulcher.

/r/wow Thread Link - i.redd.it