As an example, this iconic image was created entirely in-camera using model made over sized props. This was a very complicated setup and it took us over a week to build and shoot it to my satisfaction.  It relies on lighting and compressed air to launch bits of paper and dust through the rigged set. Timing is everything.