Was David effected by the Black Goo?

David doesn't "want" anything. He's following his creator's (and DNA imprint) last mission, which is now his mission. If David simply "carries" Weyland's DNA, he can inject this into his experiments. Weyland's whole narcissistic view is what generated the story in the first place ..... the likelihood is that the engineers were doomed by the same feelings. David - unlike all other players in the game - has the chance to be the one and true Creator from outside of all this. He can create freely. He is not "involved" due to his special status as not necessarily "living"

For Weyland, children did not work out so well. In fact, he created a son because he despised his daughter. He was more pleased with his manufactured creation than his natural one, mostly due to the fact that he could EXIST more through David than Vickers. She just wanted him dead.

David may simply be on a harmless mission to follow his creators wish to keep him alive forever. 

Remember, David of the biblical story was a hero. He was considered an ancestor of Jesus ... a new messiah. What if David reads the bible, then tries to figure out if Weyland meant this to be him? What if the bible was written knowing David would come? Please queue up the Twilight Zone music ...

I think David does have independent desires/wants, separate from his primary mission.  For example, he wanted blonde hair and he wanted Shaw's crucifix. 

Interesting angle on the biblical reference for David's name.  He did defeat a giant.  Would David see that story as a mandate to do the same with the current crop of giants (engineers)? 

What if David drinks the black goo as a sacrificial moment, like the first engineer did in prometheus?

The black goo only infects organics. So, David was unaffected by it.

This is similar to how the Xenomorphs cannot use synthetics as hosts.

@Foxxy_User

But we learned from the Walter video that DNA is combined into synthetics somehow. I would imagine David has at least some Weyland DNA, as clued by "closest thing to a son he will ever have". I'm thinking this may play a part in things. David's sacrifice would aide in helping Weyland "not die". Although David could simply extract and use the DNA from himself I would imagine too. Who knows?!

Yes indeed, we shall soon see just what David and Elizabeth ended up doing with the black goo. 

Looking at the trailer, we see people approaching egg fields, with face-huggers ready to pounce.  Was this pre-existing or something David and Shaw had a hand in? 

I'm betting that David had something to do with that, but time will tell.