Need for tightness to kill all vibration varies.
Setups with a lot of preload, like you ususally find in the Supersport/Lightning often need tighter guides than other guns,
as the preload opens the spring ID when the gun is assembled.

As you say, tight guides often gets most of the lubricant scraped off.
If there is no visible heavy wear marks on your spring/guide, I'd leave it alone, or perhaps smear some high content moly grease between the coils.