Good leaders always lead from the front. There's nothing special about this "knowledge work". It's the same as any other industrial job in this respect. A good foreman can do everyone's job better than them and knows how to keep the higher ups off your back. They're someone you look up to professionally. There's no way you can look up to someone who can't do the job well.