Asymptotically flat black holes in Horndeski theory and beyond