It needs to be said: SOTFS does more wrong than right and the only reason people praise it is because they played DS2 at launch, hated a few areas like Shrine of Amana prepatch, then replayed through DS2 through SOTFS and thought SOTFS is what made the positive changes to the game : it did not, patches fixed areas like amana, SOTFS has nothing to do with it.
SOTFS completely botched the Iron Keep and added random changes like trying very hard to make the worse areas of the game like Heide more interesting but rather than interesting the changes just make the areas a slog. Heide was uninteresting before but you quickly ran through and forgot about it. Now there's a gauntlet of idiocy added on top of the groups of giant armor dudes that aggro when you defeat the main area boss and there's a drake guarding not-ornstein which has no interesting moves but a ton of hp.
It's supposedly a little of a graphic upgrade but I barely notice it too.