I grew up there having moved from Portland/Aloha. It was a great place to grow up as a kid, though I did feel a bit of an outsider because many of the people who lived there (late 70s, early 80's) were all related. Also, I was pretty much a city boy with the attitudes that come with that.
In any case, it was a fun place and the people were very friendly. Lots of farmers and blue-collar workers, but the white-collar people never felt out of place. Lots of outdoorsmen and their ativities dominate the culture there - hunting, fishing, camping. I'm not sure if the Aurora Jubilee is still around, but that was a great festival to attend in the summer.
As the poster above notes, it is an antique capital, thus a lot of tourists on the weekend. There were also some really nice restaurants back in the day - Chez Moustache?
The school district is North Marion. It seemed adequate when I was there, though I'm not sure they felt the same about me.
The only drawback is that most of your shopping will have to be done in Canby. So expect to put some miles on the car.
In all, I think Aurora is a great place for anyone, but especially for those with children, and those who have an interest in history and the arts.