I think only some are underrated, such as PiperTTS, Immich, HeidiSQL, and ShotCut. Also small tools like rsync are widely used, but their maintainers often don't receive much appreciation, as these tools are as common as hammers and screwdrivers.
They need some love, thats why i have this list.