While i was there for all the wrong reasons, watching fireworks from the roof of my building at work was pretty cool. We were able to see about 8 different shows (the De Anza show being the closest and thus the largest), of varying intensity and size. I think we saw the Great America show, the downtown San Jose show, the Shoreline show, and we think one of the others might be the Santa Clara show. Most of them kindly held their finales during different minutes, so we were able to watch several end-game blowouts.
I've seen lots of fireworks in my time, but never just stood and slowly rotated, watching so many at once. Pretty neat.