I have taken light trails at night before but it only last week when I really invested effort at it.
I along with three friends climbed up the Cahill Expressway and looked down the Rocks to shoot this. It is an amazing spot for pictures of the Rocks as well as Circular Quay.