I'd say 6-8 weeks is about the limit. Yeast autolysis (decaying dead yeast) gives off a burnt rubber, vegemite, marmite, bouillon cubes kinda flavor and aroma. Higher alcohol will kill yeast faster, so 8 weeks maybe too long, but those beers are usually more robust too, hiding off flavors better.
Most beers are done fermenting after 1-2 weeks, leaving them on the yeast cake any longer has no benefit. If you want to add fruit or other fermentables and leave them on the yeast cake for another 4 weeks you may be stretching it. A week of dry hopping after the 2 weeks of fermentation is well within the safe period. Cold crashing is outside this safe period because of the very low, near freezing temperatures, slowing down or stalling cell death and decay reactions.
Because of this safe period, secondaries are generally not needed, or even recommended as they can (and will) create problems if not done correctly. Racking to secondaries is actually quite an advanced technique, where one tries to limit the amount of oxygen exposure and uptake. Not always an easy feat for homebrewers, given the small volumes we deal with.
For long term aging, long secondary fermentations, sours, etc. secondaries absolutely have a valid use. Just not for the majority of everyday, run of the mill brews.