A couple of jobs ago - if you were in 3+ days a week, you got allocated a desk. Otherwise, you could book desks - and you could book a van of desks for your team. Teams were encouraged all to be in on the same day to have face-to-face team meetings and collaboration. It did not take account of our teams which were spread across different countries, but otherwise, it worked quite well
One job ago, those in every day had desks allocated. Otherwise, you could book a desk, but I only had to be once a week, so not really a problem.
Current job - I am in every dayand have a desk allocated. Others change sites or can WFH (I can't in my role) but you can book hot desks, and it seems in practice that most people use the same desks. For other departments which have mostly been WFH, they have mandated teams getting together onside once a month, which has caused a bit of a stir (not unreasonably) in places where they've actually closed the office, with lots of questions round travel expenses, which is mostly irrelevant to me Again, there's an emphasis in collaboration and knowledge transfer , there are also riles about you must be in the office with new staff on their first week.
I've always had clear desk policies because of data protection.
I think hotdesking can work okay if managed well, with a booking system - and for staff who move sites or also WFH, it makes sense. You also need enough desks. I think it is an issue when there aren't.