The Cosmic Ultraviolet Baryon Survey (CUBS). VII. On the warm-hot circumgalactic medium probed by O VI and Ne VIII at 0.4 ≲ z ≲ 0.7