Although I'm sure it's on a case by case basis, and in my limited experience, I would say sGPA carries a lot of weight in an application.
I know someone who went to college planning on getting an art degree and going to work for Pixar, and when ahe took her first required science course at the end of her second year, ran into a professor who saw she had a gift for biology. It was too late in the game for her to change majors, so she graduated with a Fine Arts degree (in Pottery) and then took an extra 2 years to finish all the prereqs for med school. In the end, she had a 3.6ish cGPA (ironically thanks to all the B's she got in art classes), but a 4.0 sGPA, and a 24m for MCAT. She's in med school now.