Just like Quake 1, if you already own Quake 2, the enhanced version is available as a free update. Although unlike Quake 1, Quake 2: Enhanced is also available on GOG day 1.
In addition to visual updates, there's a new episode "Call of the Machine", Quake 2 N64, a pass to the enemy AI which changes a few behaviors and attacks, removes machine gun recoil, a new infinite use item that shows the player where to go next, and a number of other qol and accessibility options.
Anecdotally, I find the addition of Q2 N64 very appealing. It's a mish-mash of pared-down maps from vanilla Q2 and the expansions in a strictly linear fashion - no backtracking. Of course, there's also changes to the lighting and a new OST by Aubrey Hodges. Being able to control the game from keyboard / mouse is a godsend. I played the game in emulator with a modern gamepad and it was barely, barely doable, even when I could manually set deadzones and sensitivities and the like. It was awful.
I noticed a few things while playing the N64 campaign.
It's not 1:1 parity with the console version, and it's not meant to be (and that's a good thing, actually).
How it works is they use N64 textures, OST, and maps. Everything else is from the new engine - including the new enemy AI changes and balance adjustments, etc.
A good portion of the game is spent in anti-gravity. You may not have the rocket launcher, or much ammo for it yet, relying on grenades to take down bigger baddies like enforcers or tanks. The trajectory of a grenade on authentic hardware is net positive, so it's about impossible to aim. On Q2 Enhanced, it just means the grenade fires straight out of the barrel. Little things like that stand out.
The Nintendo 64 campaign on Hard, with deaths, took me about 3 hours. This is how I have always wanted to play this version of the game. It's indescribably better than trying to play it on an actual Nintendo 64 or even emulated.