While I would definitely say it's a good idea to study harder questions, my experience has been similar to yours in that I don't recall ever being asked a more difficult leetcode/HackerRank style question in an interview.

That being said, I've never interviewed at FAANG before. I suspect they are the ones who would be asking the tougher questions if only just to reduce the absurd number of applicants they receive.