The offices I've worked in gave private offices to roles that need to discuss confidential concerns. Which means all people managers, which in turns means all executives. I also have had a private office as an individual tech contributor, but most places just gave us cubes.
I agree that open offices suck, btw. I'd much more readily go back to an office if I got my own space.