Continuing in this vein:

not the brightest light on the porch, not the sharpest tool in the shed; and a variant on the hamster one that Ed T mentions:

the wheel is still turning, but the hamster is dead.