Hi all, I saw a program a year or two ago that would display spectral
data very prettily and also give note names.  I hate that I'm having
trouble describing it accurately, I just remember it as a "very
musical spectrogram program"  ... argh... does anybody know what I'm
talking about?
    

Sonic Visualiser and some of the tools bundled with CLAM come to mind...
http://www.sonicvisualiser.org/
http://clam-project.org/

  
Baudline has always been very powerful as well:
http://www.baudline.com/index.html