I think they are intended to be helpful, but they are adopted as CYA that have the side benefit of improving security.
Sometimes. Other times they have the side effect of worsening security, as line employees have to deal with bullshit "security" rules and invent undocumented, untracked workarounds just to be able to do their jobs at all.