This wasn't some new policy of Lufthansa though, apparently it's their SOP for basically all airports. Outside the US, I'm not sure if visual approaches are all that common for (heavy) aircraft at night. Overall, the reason that SFO wants visual approaches is to increase rate of landing, and the reason that Lufthansa wants ILS is to increase safety -- your phrasing "Lufthasa is the one making this hard on everyone" just seems wrong, having more safety seems totally justified and reasonable here.
I'm actually surprised SFO still allows visual approaches at night after that Air Canada 759 flight nearly landed on the taxiway ~5 years ago (https://www.youtube.com/watch?v=aGQlQFn0euI).
I'm actually surprised SFO still allows visual approaches at night after that Air Canada 759 flight nearly landed on the taxiway ~5 years ago (https://www.youtube.com/watch?v=aGQlQFn0euI).