I've had standard decking for many years and from before composite decking became available.
It's held up pretty well but I went for the thicker boards and have re-treated it every year. The reality is that it's the timber frame it sits on that decays first, as there is no way of topping up the rot treatment, so I would say 10 years would be good for a well constructed timber frame that rests on pads to keep most of it from sitting in standing water.
I would personally look at composite if I was planning on being somewhere for more than about 7 years. By that time issues could be emerging with a timber deck but composite should still look good with just the occasional pressure wash. It is a major pain having to replace wooden joists as not only do you have to take it all apart, you have to re-build it in precisely the same manner as the original structure.