Since 2 or more teams play in the CL, I think mid 90s onwards, they missed it once. In 2007 when Stuttgart won and Schalke and Bremen were 2nd and 3rd. Under current rules however, Bayern would have still qualified since they came in 4th.
Competition and chance of relegation is all nice, but...