MacBook – How to disable the MacBook trackpad click but keep the tap enabled

You can rule out SteerMouse, I just connected a second mouse and there is only one setting for double-click delay shown. Based on that I'm doubtful of USB Overdrive's claim: "The USB Overdrive can easily handle several USB devices at once and can assign different settings to each one." - but it's probably worth a look!

I think ControllerMate could do it if the developer felt like it - it's a way more configurable approach and is flexible enough to build complex control schemes for HOTAS game controllers. You should register your interest in being able to control the Magic Trackpad with a quick email. I don't know for sure that ControllerMate can't do what you want, it all depends on whether its building block approach sees a "Source" for each mouse-like device or whether it just uses the kernel's mouse driver output and sees an aggregate of control input for the two devices. There is a time-limited trial available.

Seeing as my original question was brought up due to a lack of compatibility with Mountain Lion from MiddleClick, I think that this answer should suffice:

As of 19AUG12, MiddleClick has been updated to support Mountain Lion and is now available for download.