He can’t see the future IMO. He decides what he wants to happen, tells people it’s gonna happen, then manipulates them into whatever positions they need to be in to make it happen. End result is it looks like he predicted it when in fact he just engineered the whole situation.
He knew the arrow would hit David because he gave them both the same map, told them both where to go, and I believe that was Cupid’s bow and arrow, so it he knew Snow was destined to shoot Charming with it.
He said he was invested in Snow’s future because he was setting her and Charming up to give him the ingredients to make love, so he could then include their love (ie: Emma) as the antidote to the curse he was planning on creating.