Still good, but beware the new changes.
I would only recommend buying this game if you want to see Doom 3 in 3D, or you have no qualms about the loss of mods or the censorship. Even then, supporting a move like this is difficult to justify. How much you lose by buying this version is very noticeable versus what you could gain.
Pros - - The new high-resolution textures; Running on ID Tech 5, the RAGE engine, this game looks even more gorgeous now than it did back in 2004; - Five games in one; You get Doom 1 (Ultimate) and 2, Doom 3, Resurrection of Evil, and the Lost Missions.
Cons - - Censorship; I've noticed a lot of this while playing, mostly in the original Doom games you get with this title; The red crosses on med-kits and stim-packs are now red/white pills, and the secret Wolfenstein maps have been heavily censored, removing all (censored word) references/images,...