I think it depends on more than one thing. As others have posted, if the person were somehow prominent or famous, the value could increase. But not necessarily.

Also, I think it could devalue a gun significantly, if the engraving of the name were done exceptionally poorly and somehow distracting, such as inordinately large or in a very conspicuous location, etc, etc.