I have many overnighting experiences in airports. The best one ever was in YYC. I told a security guard that I couldnt afford $150 for the airport hotel and asked if there was anywhere I could sleep. He directed me to a relatively quiet area and said that everyone who was overnighting was encouraged to sleep there. I found a nice spot on the floor and slept with about 20 others.
It was reasonably quiet and I felt good knowing that security was keeping an eye on the area.
Go YYC!