In Raleigh, our new employee orientation actually lasts three days, and typically, HR likes to choose at least two different locations to hold orientation so that new employees can visit a couple new buildings. Almost every department gets to make at least a short presentation, which not only gives you a feel for the department's work (and the fact that they exist, in the case of lesser-known departments like Community Development), but also gives you a contact in each department should you have questions. We also incorporate National Incident Management System training into our orientation, and even though it can be lengthy, knowing you're prepared in the event of an emergency does give you a sense of ownership within the city.
Individual departments also do their own orientation academies, and the one I did for Parks and Recreation included travelling around Raleigh in a city trolley, visiting several parks, and even riding one of the park carousels. We definitely try to balance out the wordy parts with the fun parts!
I've attached a copy of our most recent citywide orientation schedule. Hope that helps!