The Nismo's seem like a good street cam based on the review because they say that it keeps the torque down low and opens it up at the top. Basically a well mannered car with more top end.
Keep in mind though, after reading the whole review and looking at the numbers, they have headers, intake and cams and the amount of extra power they make is pitiful for the $3000+ in those three mods alone (with install).
While I was at it, i found this
nissanperformancemag.com
"Q: I've heard a lot about how cams work, but I'm still a little confused. Can you explain how aftermarket cams can add power to my ride?
A: The camshafts control how long and how much your valves are open. There are three important factors of the cam that affect their performance: duration, or the number of degrees the valve is held open by the cam; lift, the height the valve is lifted on the valve seat; and overlap, the period when both the intake and exhaust valves are open at the same time. At high rpm, there is less time to fill the cylinder. A cam with greater duration keeps the valves open for increased degrees of crank rotation allowing the cylinder more time to fill. The more lift a cam has, the more flow that passes through the higher lifted valve. For all out crazy engine setups, you want a long duration and as much lift as possible. However, stock and mild race cars shouldn't use such a wild cam. When the duration is increased, the exhaust valve opens earlier and you may experience blowdown, which is gasses expanding during the power stroke that are blown back down the exhaust pipe. Blowdown creates a power loss during the power stroke because it quickly rids the engine of the pressure it needs to create power. Increasing overlap increases the time between the opening and closing of the cams points. Overlap can cause reversion at low rpm, which is exhaust gas pushed back up the intake port. Reversion dilutes the intake charge preventing the cylinders from completely filling, and decreases the cylinder pressure at low speeds causing low speed misfire. This low speed misfire causes lots of hydrocarbon pollution which is why stock cams have very little overlap (do you want to chew your air?). Full racing cams usually have around 305 degrees of duration and 0.5" of lift, which produces raging top end power at the expense of low end power, but idle poorly and will blow emissions tests off the charts! A good aftermarket cam pulls around 4000-7500 rpms with a faint lopey sound at idle and will have about 265 degrees of duration, 0.42" lift, and 30 degrees of overlap. This type of cam will work well with all the bolt-ons and can be used in a daily driver. A stock cam has about 240 degrees of duration, 0.39" lift, and 15 degrees of overlap. The stock cams work well between 700-6500 rpm and idle very smoothly. One caveat: if you aren't too familiar with your engine bay, have a professional install your cams. You can easily blow an engine if you don't take all the necessary precautions during installation. "
Chris