It really depends on who they are and how good at their job they are. I’ve seen more bad ones than good ones.

I prefer a lead or senior developer to have the role rather than a dedicated non- or even former- developer.

When a good lead dev with good communication skills and experience has the role it can be awesome.