Wow, finally a good SciFi movie again.
First of all I can say: As long as you don't expect Alien you'll be fine.
Of course the movie has it's flaws, but rather than me ranting on here is the awesome review by the Totally Rad Show. Well basically I share the same opinion. revision3.com/trs/prometheus (contains spoilers)
Over all I am happy to have payed my well earned money on this film. I am stoked for the second movie, maybe it'll fill some plot holes.