In some ridiculously well lit areas my character can still be seen at sneak being level 100; would it be worth to enchant an item with the fortify sneak enchantment? how much of a difference does it make?

Save game. Try for yourself. Continue playing if it works - load a save if it doesn't. Report results. Enjoy respect of other players.