I kind of got the feeling that Nearly Headless Nick kind of regrets coming back as a ghost. Because Dumbledore didn't fear death in the least (his words: "To the well-organized mind, death is but the next great adventure"), he wouldn't be clinging to the sort of half-life ghosts have.
Talking portrait, however, DEFINATELY.