Noise figure can be misleading, and don't have much to do with the satellite signal itself, they are numbers related to the amplifier in the LNB.
All amplifiers inject noise duing amplification, audio, video or LNB amplifiers.
For Ku LNBs the lower the number the less noise it would inject, but they also tend to not give you as much gain, so your actual signal level may go down but you are getting a cleaner signal.
Dish size, period, is the best improvement you can make for better signal levels.
If you are at the edge of a satellites footprint or it is low on your horizon so you are going through a lot of atmosphere and are also get earth radiated ku freqencies then a lower db LNB may get you a watchable picture over a factory DN LNB.
Most who spend the money on a lower db LNB do not notice a difference, and the money would have been better spent on a larger dish.