Anyone ever use a fog/smoke machine on a shoot?

[RealJasonBourne]

Im doing a shoot in a graveyard and I think it would be cool if there was fog in the background. Can I just buy any fog/smoke machine or is it worth it to buy a professional one? Like I see this one on craigslist for $500, and the guy says it was worth $2000. There also cheap fog machines for like $50 at party stores

 

[sfoster]

Any good hazers for indoors in the $500-700 range?
I looked up LeMaitre and found one that is $1000

Going back through some old game of thrones episodes i noticed they used these things on almost every indoor shot.