Red Hand of Doom was even incorporated into the fluff of 4e. Its Elsir Vale setting was used in Dungeon's Scales of War adventure path (which came out in early 4e).
Red Hand of Doom is a really cool adventure! But i remember some people grumbling about it when it came out, so i think only time will tell on whether or not some 4e adventures will be able to stand