My experience has been that vibrating toys can be fun, but the prostate can become numb to the vibrations, and then, the fun is no longer there. It is fun while it lasts. Also, be sure to get one with enough power, I’ve used some which were mosquito-powered, and very disappointing.
The manual prostate massagers, you can apply a different type of pressure, so the sensations may last longer, and I’ve been able to have multiple orgasms. You can determine the intensity of the massage better, too.
Design makes a difference with vibrating, or manual, so you may need to test what works best for your particular body.
Fingers are great, my first prostate massages were with my fingers, and I nearly fell off the chair, the orgasm was so intense, but doing it on yourself is a lot more difficult to reach, (and keep reaching,) for very long.