Gain usually comes with additional noise. The less gain you have overall the less noise.
Phono stages have the most gain, and most prone to noise, followed by line level preamplifier circuits.
That is all in theory though. Over the last 20-40 years solid state has gotten very very quiet so it’s not usually worth sweating these details vs. say room treatments, listener location, etc.
The one pet peeve I have though is that most preamps still have WAY too much gain, maybe due to the days when radio might pick up a weak station and you had to compensate for it with the volume control. If I used a tube pre especially I'd be tempted to reduce the gain quite a bit.