A Critical Assessment of the Neurodestructive and Neuroprotective Effects of Nitric Oxide