What do you want in a software PM?
DavidSJ: Other commenters have said it but it bears repeating: the single most important thing you can do is be honest and straight.  Programmers can detect bullshit, and it's about the worst thing possible for morale.