I liked how when Geordi would walk onto the bridge, the engineering console would 'power up'. It was one of the few instances of seeing the ship being "90 percent automatic", as stated by Geordi himself in Contagion.
Not entirely true. There were plenty of times when Geordi got to the console where he had to verbally initiate the console's activation. Any time when the system seems to power up on its own it could be because the line just wasn't in the script (but maybe implied to be said if not verbally heard) or maybe Geordi activated it by touching a "button" on the console.
It never seemed to me the console powered up entirely on its own.