Stuxnet is a masterpiece in terms of achieving goals while attacking hard to hit, network isolated facilities.

https://en.wikipedia.org/wiki/Stuxnet

It would be very interesting to see the next Stuxnet class viruses, sponsored by major companies/countries. I'm fairly sure there are some already running in the wild.