I can't see Davos leading teh Night's Watch. First off, he won't forsake is family like all the NW has to do. Second, he's not a commander. Third, nobody will vote for him. The NW needs a commander. They don't realize it today, but they will.
The point that Stannis was more of a distraction to the real power struggle is why him dying here is so bad, because, unlike Balon, we have spent hours and hours with him. It means that there must be more to him than his desire to be a player.