Do investors really look to only support projects that are already finished?

Yes. Minimum Viable Product called MVP.

That's rather counter-intuitive and doesn't make sense to me.

Explains why you're deluded into thinking you were making sense.