[sfeats]

I would just like to highlight one of your criteria: Is your prospective advisor... genuinely excited about you?

This is more important for future academic prospects than I would have anticipated going into my PhD program. I fit your list of attributes for all other criteria save this one. And without my supervisors enthusiasm for my work or my future prospects I've started losing confidence in myself and in my abilities. More than confidence, I'm missing out on networking opportunities due to his lack of interest.

[wotzotz]

That is so rough. I don't know exactly what your situation is, but there might still be options. If you're at the dissertating stage, you might have a committee member that is more stoked with stuff you're doing. You might be able to use them as your unofficial mentor to cover for deficiencies in the relationship with your primary advisor.