Yeah I don't really think LFR adds anything to the game. It's probably the least fun activity in the entire game, and if the whole point is really just to let people see content they can just do that on Youtube or Twitch, so I don't really see the benefit.
That being said, it also doesn't really hurt anything. I haven't felt the need to do it in like 3 expansions, so as long as they continue to make sure that it doesn't feel required for any reason I don't think it makes much of a difference either way.
But I mean removing LFR isn't going to make me excited, I won't be happy and instantly resubscribe if it's gone, I also wouldn't quit the game if it were removed. I generally don't even think about it.