Voyager 2 is the only spacecraft to have flown by Neptune, in 1989. It was incredibly successful in gathering valuable data about the planet, its moons, and its magnetic field. However, it wasn't designed to orbit Neptune or land on it.
Therefore, there is no "most successful" space probe launched to Neptune.