At 40 or any age, play appropriate tees for any course. Some back, some 2nd to back. It's not about being a wuss. It's about identifyig a realistic and appropriate challenge.
I'm 54, and base my decision on slope, course rating, and the length of the par-3's.