Those pictures you posted are of someone's Tahoe who goes to this forum. I forget who, but he only posted those pictures like a few weeks ago.
I personally think a drop that low looks terrible on these vehicles. Makes it look too long and too close to the ground. The stock ride height on the limited (which is already a 1.5" drop from the other models I believe) is perfect in my opinion.
Man, what I would do for one of these trucks. I would make it a speed machine, that is for sure. I mean, I would keep all the stock components hidden away in a storage area, so when the time comes that these limited edition SUV's really have some value, then I could revert it back to stock... but for my own purposes, I would totally race it out. I'm talking big block, slicks in the rear, beefed up suspension, brakes, sway bars, new exhaust system, etc. It was originally meant to be a performance "SS" Tahoe, but they dropped the SS brand. I'd even go so far as to replace all the emblems on it with vintage 1960's SS emblems from a Chevelle or something. That would be totally awesome.