Engineering Leadership Interviews
I am not sure I really recommend this book, but for someone who asks the exact above question ("What do other people experience when managing software people?"), it would be hard to beat just a ton of interviews in a book, which this is.