Image from Cabinet Magazine
Appearantly the electric company in the Toronto area has built numerous substations that look from the outside like an average house in the neighborhood.  I imagine this adds substantial cost but I’ll bet people don’t complain too much about having one go in across the street when compared with typical substations.

See the BLDGBLOG for more photos and discussion.