Neutrino emission characteristics and detection opportunities based on three-dimensional supernova simulations