Here's my take: It's an individual and subjective thing. While I could never fathom the thought of an auto NSX, I have witnessed the absolute joy one owner has had with his. He absolutely loved driving it. As a passenger riding with him, I'm thinking an auto is just not right in an NSX, yet it bothered him none. In fact, I'm quite sure he preferred it. Will it be less powerful than a manual? Sure it will. But what are you looking to accomplish? That's the magic question. BTW, the NSX is far from a torque monster - don't tell your hubby though!
However, here's my .02 worth of advice: If you haven't driven a manual NSX, and are somehow afraid of it - go drive one if you can. The gear box is one of the finest attributes it has. For even a beginner it would be a wonderful platform to learn in, provided you can understand how to properly use the clutch.