Thread necromancy, but I just tried the latest release of darktable and it looks pretty good.. If you're looking for a free alternative to Lightroom, definitely worth a try (I'm on a mac, but it's also linux and windows)
The file management seems pretty good, the editing is different to lightroom but seems excellent, the interface is also really good and surprisingly simple to learn.
This plus affinity could solve the lightroom + photoshop question.