My experience has been the same. While I don't think NO2 and the 'pump' does anything for me in a physological sense, it sure does in a psychological sense.
The same could be said for having a great workout tape. If it gets you feeling good, then you probably will do better, lift more...