It depends on the game and the player. Personally I don't think The 7th Guest Anniversary, Blade Runner "EE", etc, is worth it at all vs playing the original through ScummVM. Nor have I found any reason to want Doom 1-2 "Enhanced" vs GZDoom when 1. All these new Bethesda "EE's" are Windows only (whereas most source-ports are cross platform) and 2. All the other same-engine, same-era games (Heretic, Hexen, Strife, etc) use GZDoom anyway and it feels weird splitting off some Doom Engine games but not others for the sake of consoles (which are the biggest drive for 'needing' to endlessly remaster already-playing-well games far more than PC's). From what I've read, Doom 1-2 Enhanced uses Unity Engine mostly as an input wrapper for the Doom Engine anyway, ie, engine-within-an-engine seems to be an overly-convoluted 'solution' vs using existing quality source ports directly. I also think games like Hedon, Selaco, etc, have more "character" for using GZDoom rather than being yet another generic Unity Engine clone.

On the other hand, I've found BeamDog games to be technically solid and conversely the EE's are cross-platform (vs Windows-only originals). They have some advantages even over patched originals (eg, Ultrawide support, 4k scaling, etc). The biggest reason for negative reviews for those is the pricing where upon launch sale prices of Baldur's Gate EE vs original increased +400-500% overnight plus extra was charged on top for a NWN:EE "DLC" soundtrack (that came bundled for free with NWN:DE original game) plus forcibly removing the originals from sale is never a good thing. NWN:EE is technically solid but the problem there is that (as predicted), original game = mods were open and available to all via NeverwinterVault, whereas "EE" has ended up 'encouraging' gating content behind Steam Workshop which benefits Steam far more than long-term NWN fans.

Well, for one it depends on whether you actually still want to actively play the games, of course. And naturally, one advantage of the remasters/enhanced versions over modding is that they're less of a hassle to set up and work right out of the box.

I tried to mod Quake and Quake 2 to make them more accessible, even tried the Quake 2 RTX version (without my GPU supporting RTX though), but in the end I was still much happier with the Enhanced versions. As far as I know they also include the original soundtracks again, while GOG's classic versions didn't, you had to (illegally) download the music and mod it in yourself. So personally I consider these two worth it. Then again, they are bundled with the classic versions now anyway and if you already owned them you should have gotten the enhanced versions for free ...

Same with Bloodrayne: Terminal Cut. I played through it some years ago, and it was better looking and more accessible than the classic version while staying true to the original. But owners of the original also got it for free (and it's neither by BD nor Bethesda nor Nightdive, heh).

PowerSlave: Exhumed is actually quite a bit different in gameplay than Powerslave PC, from what I understand, as it blends the PlayStation & Saturn versions into one, and I read that while the original PC version is a classic linear shooter, these console version and thereby also the new "exhumed" PC version are more open, metroidvania-lite that have you backtrack and freely access levels from a hub.

Neverwinter Nights EE I consider worth it, too, but I'm mostly interested in the game for its custom/community made content. The EE did loosen a lot of the shackles behind the scenes and gave modders and module authors more space to work with, meaning they can now do cooler things with the toolset than before, and eventually players will profit from it too (partially even now). And as a player, I love that I can e.g. mod in a lot more heads to choose from during character creation, that I can easily switch out the menu screen picture and background music without having to mess with the game files, that I can toggle on an aiming assistant for spells in some modules, so I'll know where the fireball will actually hit and can avoid hurting my companions etc. Lots of smaller ease-of-use and customizing features. Besides, the server lists work again, making it much easier to find and connect to online worlds. Many of them require the EE now. And some classic single player modules were "enhanced" with new graphics, new voiceovers, new quests etc. and these can also be played with the EE only. Most (though not all) legacy modules still work fine with the EE, so even though I still have NWN Diamond, I haven't felt the need to start it anymore ever since I started using the EE.

If, on the other hand, all the above doesn't interest you about NWN and you only want to (re)play the official campaigns, I'd say it's probably NOT worth it, as they haven't really changed at all. Or maybe they even work worse in part now due to new bugs being introduced? But I'm not sure about that, as they aren't really my area of interest and I just occasionally skimmed forum posts on the topic which may or may not be mistaken or outdated by now. Graphically, at least at first sight, nothing much has been "enhanced" in NWN EE, if you play official unmodded campaigns (but graphics never really were Beandog's priority in "enhancing" NWN, the original devs now working at BD mostly just wanted to add more stuff to support the modding community).

Bethesda:
Quake 1 Enhanced - absolutely, but it's free for any owner anyway

Quake 2 Enhanced - yes and no, it's better, there is a nice additional campaign plus the N64 campaign, but some gamers can't stand the changes in the AI for some enemy types, and you can't disable the damage indicators (those red lines around the crosshair) and I can't stand those indicators personally.

Doom 64 EX - absolutely yes

Beamdog:

Baldur's Gate 1 EE + new campaign DLC - yes and no, they cured most if not all the bugs which they introduced previously (mainly with the pathfinding), but they implemented atrocious cutscenes (in my opinion) instead of original ones, there are new companions with voice lines and special quests, but if you want to play with them and with the canon good party you might have some serious issues, playing the evil character might help (it's my opinion, I might be wrong), also the latest patch broke my favorite mods compatibility and to this day I don't know if there is a fix for this. New campaign can be nice I guess, plus there is a lot of praise for The Black Pits mini campaign (play it first if you want to have the full experience with evil hero in BG1). As for the additional fixes taken from community mods, I'm not sure, I think there is one more meeting with Elminister, there are addiitonal storage for gems, scrolls and potions and you can stack bullets and arrors in larger quantities and that's it, I'm almost at the end and I don't even remember an extra meeting with the Elminister (there are no more additional content so far).

Baldur's Gate 2 EE - this is a yes, they retained original cutscenes, the latest patch fixed that pathfinding issues, new evil companion is not bad.

Planescape Torment EE - absolutely yes

Icewind Date 1 EE - I'm not sure about this, the original game was good enough and they refused to invest into making a sequel, because it's too expensive for them (why couldn't they at least try to fundraise it)

Neverwinter Nights EE - absolutely yes

NightDive Studios

All games, even the Blade Runner - is a yes for me. They are doing the god's work. I loved the Turok games, Blood: Fresh Supply (latest patch, single player only), what they did with Quake (except for the damage indicators for Quake 2), System Shock EE (for the first time in my life I was able to play the game in comfort), Powerslave: Exhumed (I could only dream to play that game), Doom 64 EX (even though it's plagued with Bethesda menu, everything else is top notch), Strife: Veteran Edition (I can't express how I love that game and it works perfectly) plus a few other games which I missed, some of which they only produced (e.g. Wizardry 8).

I take it back, only today I was informed that those can be disabled through the console:
scr_damageindicators 0

I checked it and it works, this makes Quake 2 Re-release version a certain "yes" in my opinion.

Also today it received it's first update, you can read about the changes here (please note that there is no menu setting to turn off the damage indicators, use the console cvar option mentioned above):

https://store.steampowered.com/news/app/2320/view/3748740708262999111

https://bethesda.net/en/article/1iWTUzOktuRN3fDlXVV47r/quake-ii-update-1-release-notes
Good point, you are right.