I felt like for 2000 they took the 98 look and just nicely honed it. Things like the gradient in the title bar of windows, or switching from the default aqua of 98 to the nice blue of 2000. Little things that pushed this overall look and feel to a nice sheen.
I do remember back in the day the name was confusing, up till that point all DOS based Windows had a year name, and all NT based windows were, well, called NT :) I remember people being surprised to find out 2000 was an NT based Windows.
Well, it was the first Windows based on the NT kernel that found its way to consumers' computers. Well, at least the computers of enthusiasts and power users – as far as Microsoft was concerned, the 2000 was still meant for workstations and servers and did not have a "Home" edition. For home use there was the much-maligned Windows ME which ended up being the last non-NT, not-memory-protected, still-sorta-just-a-fancy-shell-over-DOS Windows that Microsoft released. Only with XP did Microsoft completely unify their "home" and "professional" lines.
I feel like Win 2k was "underappreciated" because of that surprise, but also to the point of the author. The visual design was not a huge improvement over previous editions. I'm sure it didn't "feel" like an upgrade.