there are quite a few good noise reduction plugins, and unless your wallet will allow the entire CEDAR suite I think you are going to need a couple to cover all contingencies.
My tool chest has too many, the few I use include:
Izotope RX - probably the top of the heap today, and it is fairly intuitive, meaning you can get good results without a lot of artifacts without too much tweaking.
Accusonus ERA-D - this was distributed by Plugin Alliance, but is now available directly from the developer. It works really well on all sorts of noise, but it requires a bit of effort to get the best results. Other than ease of use I'd call it a tie with RX. The strange thing is one will work better on a track, and the next track the other will win. Very strange.
Sony/Sound Forge/Magix/whoever??? - There was a noise reduction plugin developed for Sound Forge, I'm pretty sure at some point they just bundled it with the editor, and I don't know if it can still be purchased separately. Which is too bad. Like Sound Forge it is FAST, and relatively easy to use, and for broadband noise, especially things like HVAC, I think it is probably still the best bet out there. In fairness, it was my only tool for a number of years (big number) so I pretty much know what settings to start from. If you are just getting started with noise reduction it might not be easy. I have no way to judge<G>!
I've used the demo versions of the Waves noise reduction plugins a couple times, always hoping that they'll knock it out of the park. Thus far I've been impressed with the results, but they offer me nothing new, no better noise reduction, no better workflow... might be a good starting point, but I've found no compelling reason to add them to the tools I already have.
Two things to keep in mind:
1) two or more passes with very gentle noise reduction will usually sound better than one pass with extreme settings. This applies to steady state and impulse noises.
2) it is all about the settings, and even almost 20 years later I have to listen carefully and make small adjustments to get rid of the noise without causing other problems. It is slow, tedious work.
Depending on the noise - and this does not apply to your case as described - my first pass is always to mute the noise at the heads and tails of the tracks, and sometimes even between phrases. Muting between notes can work, but often sounds unnatural.
For motorboating I would be inclined to start with a gate, a drum kit can cover a multitude of sins, unless of course it doesn't. In the bad old days I had a MIDI controlled gate from Drawmer that let me program in where the gate opened and closed... pretty remarkable at the time. I can now do the same thing more quickly, and more accurately with automated volume or mutes.
Good luck!