Hey Arshad,
Yellow Tops are great but the ones at Costco are not the right size. Since they are deep cycle batteries, they allow the battery to be almost fully drained multiple times without damage. Yellow Tops also hold the charge longer and are dry cells. Costco Yellow Top prices have dropped from $225 down to $180 so it's not a bad deal.
Then again, the Acura battery, which I recently bought because my previous owner had a "SEARS" battery! It couldn't hold a charge unless I was driving it no less than 3-4 days. The Canadian Winter killed the SoCal Sears battery!
I also have an Odyssey lightweight battery but unless you drive the NSX everyday, it will need to be on a Battery tender all the time. Since they are motorcycle batteries, don't expect those to supplement your charging system like the Yellow Top or even OEM for that matter.
FYI, the OEM battery is not built to withstand deep cycle without damage so expect that everytime your battery runs dead that it takes more life out of the battery.
Since the OEM battery has a 5 year guarantee, for $110, you really can't go wrong... At this point, I'd get one just for piece of mind. I bought mine and didn't install it for a month, left it out in the cold and it stayed charged. I installed it without having to charge it at all. Runs great.