See statements like "if you can guarantee your basement will not have water" scare me. It's an older house and I'm looking for a long term flooring solution, so that's likely a guarantee I can't make. That's why I'm leaning towards a system that can survive water (just in case). The delta fl underlay seems like a strong candidate for this. I just don't know what to put on top.
From what i have read about Delta, you add a subfloor of plywood (1/2"?) above it and you have all your choices back in play. In which case, i would would be inclined to vinyl planks or sheet flooring.