Dumbledore, Sirius, James, Lily, Lupin, Fred and all the others did not return as ghosts because they had "gone on" to the "next great adventure"; accepted the end of their lives as they knew it and moved to whatever afterlife they had.