In french, we have "they are not not the sharpest knives of the drawer" but my favorite one is "he is not the penguin who slides the furthest" :D
On the light related ones, I only know "they are not lights" which is a bit to bare bones to my taste, but works well in french