The K100d Super is the same sweet piece as the K100d
I love the pictures, especially the colors, and the crisp appearance.
I like both cameras. The only big differences are the added support for the new sonic motor drive lenses and a special dirt whacking mode that makes the sensor wagg a few times. It feels like having an accelerated version of an exicted dog sitting next to you on the couch, who is whacking his tail on the cushion when you scratch his favorite spot.
So far, I couldn't tell if it makes a difference. From what I have read, the only system that tested effective for dust removal, is the Oly system.
So, rather than letting my camera beat up my movable sensor assembly all the time, I don't use it, and will clean the sensor by hand when I start seeing those telltale dirt circles (looks like a raindrop fell on your lens, except very small, and one must be in 100% pixel view to spot it).
High ISO is great, and after experimenting with RAW processing, even iso3200 can yield good results. It may look like the image is printed on a saw dust covered canvas, but that is far better than the outright smeared results from some other, higher priced models from all manufacturers.
So - between 6MP and 10MP - not enough difference to tell, even on a billboard.
If you were to get close enough to a billboard to start seeing pixels (they are made to be viewed at distances from which their size appears to the eye like a regular magazine ad, not a painted wall!), then even 10MP won't make a difference - because the actual linear resolution factor is only increased by 1.3.
WHAT? Yes, that is right - mathematically, going from 6MP to 10MP, you only get get 1.3 pixels for every 1 pixel horizontally and vertically.
6MP ~ 3000 x 2000 pixels
10MP ~ 3800 x 2500 pixels
Just look at the figures above - the picture doesn't get that much bigger, right ?

To get noticeably better, you need a camera with at least 4 times the resolution (2 by 2, to double pixel count horizontally and vertically), so a 25MP model - with a sensor that is also 4 times the size, to avoid noise issues. Here is the problem - APS-C is half a "full frame" size for a 35mm coparable body. So, that 25MP next gen cam would need to be a step up from "full frame", aiming for a Pentax 67 sized, or Hasselblad sized instrument. You can buy one here, if you'd like
http://www.bhphotovideo.com/c/product/529439-REG/Hasselblad_70380510_H3DII_22_22_Megapixel_SLR.html
Now, if you clicked the above link, I hope you are recovering from the sticker shock by now, safely off the floor, and back on the chair
Bang/Buck wise, the K100d (and the Super) were the best thing out there, unless you need really fast focus and lots of pictures per second performance. In that case, Canon and Nikon are still the Kings. But glass with stabilization will cost you more .... still, in the future, once my K100 series bodies wear out, no more buying Pentax gear, unless they prove to me they are building what counts: fast autofocus, low noise and no streak sensors, 5 frames per second, at a price comparable to a Canon 40d. Anything less is lame and a waste of my very hard earned money.
I have enough lenses and gear and I can wait a long time now - Pentax will have to tempt me with another GOOD camera like the K100d to consider NOT switching to canikon down the line - but their management at this time is odd to say the least.