There's definitely plenty of companies out there that have stopped using LeetCode style questions. I just finished interviewing and out of the 8 companies I talked to only 1 had a single LeetCode style question and it was one of the "coding challenges" at the virtual "onsite" stage. My previous employer also didn't ask any LeetCode style questions.

It's worth pointing out that there are some questions on LeetCode that are absolutely fair game in the interview process. Questions along the lines of can you implement the logic of a rate limiter, can you implement some authorization logic, how would you deduplicate some data in a system, given some request headers can you implement X logic, etc. are all questions that can be closely tied to some LeetCode questions but are also regular day-to-day work. However these are questions where you don't have to memorize "tricks" to solve them in the amount of time you're given.

That being said FAANG companies are known to ask the typical "LeetCode" type of questions, so if you're applying to those companies expect such interview questions.