It's possible in Blender to bake an audio file to f-curves, and use it to produce a simple visualization.
I wanted to do something much more detailed (note by note). I tried creating a new workflow (using MIDI) and it was fairly successful and convenient.