Out of curiosity, if you do a multi-deck UHF and VHF, would you install two antennas on the vehicle or ever consider a diplexer setup sharing a single antenna capable of some performance on both bands?
Would depend on the vehicle, at least for me.
If I had space for two properly installed NMO mounts, I'd do two separate mounts. That gives you the most flexibility to choose the correct antenna for each band and the specific application. Yes, you can do a single multi-band antenna through a diplexer, but that usually gives you a lower gain VHF antenna and a higher gain UHF antenna. The UHF antenna would get its gain by a compressed radiation pattern that may not be ideal for your specific application. Having two separate mounts lets you choose the right antenna for the job.
Plus, I like my 1/4 wave antennas.
If I only had space for one antenna, then I'd use a good diplexer and a multiband antenna. I've been running Harris XL-200 mobile radios on my work truck for about 2 years now, and I've been happy with the multiband antennas from Larsen and EM Wave. The truck is a regular cab F350, and it already has a separate 800MHz radio plus a blade antenna for the WiFi/LTE/GPS on the Harris, so a multiple antennas (radio would need 3 for the LMR side) was not an option. Plus, the Harris uses a single RF connector for the LMR side of the radio. Adding a diplexer was an option, but really only room for one antenna on that specific truck.
A trade-off of less performance vs. less holes in the roof/intrusions to other parts of the body for antenna mounts, I suppose.
I have no problems drilling holes, been doing it for a few decades. Never once had an NMO mount leak. Ever. If I have the space and the need, I'll install as many as required.