If we're going to discuss this using small samples as evidence, I have a too-small sample to add.
I've owned 5 machines for a total of 16 years, 4 with vibe pumps, and one with a rotary (still far short of what's needed to draw any valid conclusions).
The only one that ever needed a pump replacement was the rotary.
I installed a time-delay relay to allow 5 seconds of line-pressure preinfusion before the pump started up, and the shots became more consistent. As for noise, there's no doubt that rotaries are inherently quieter, but mine was not quieter than similarly priced semi-commercial machines because of the buzzing of the machine shell when the pump operates.
It certainly was convenient to have it plumbed in, but that brings its own problems, too. The drain from my machine used to back up occasionally, seeping dirty water all over the countertop. I finally began snaking it out every few months in my regular maintenance routine and the problem stopped.
And replacing a rotary pump may be a little more difficult than replacing a vibe pump, but it's like 3 on a scale of 10 vs a 2. The rebuild route is not expensive at all.
For me, the answer to "vibe or rotary" depends on your situation. A machine with a good-sized drip tray and a reservoir that's easy to fill is not much less convenient than a plumbed in machine -- for home use, that is. I've just bought another pourover vibe pump machine because I'm moving to a new place with a granite countertop, and I don't want to drill a hole in it.
I'm sure one of the reasons we see a high percentage of commercial machines with rotary pumps is the productivity gains when you're pulling shot after shot, all day long. That alone is a sufficient justification for a rotary in such a setting.
Rick