This has always been the premise/promise of DevonThink, but I never found it quite hit the spot for me – I end up imposing organisation on it, and then we're back at your original complaint. Some users do absolutely swear by it, though.