Many scenes from the movie "Act of Valor" and "127 Hours" were shot on DSLR, along with a few scenes from "Black Swan" and "Captain America."
I have watched three of those movies in theaters and believe me, they look far from "crap" on the big screen. The footage holds up wonderfully, though...