For the ultimate pinhole, have a look at the Tortuga at Retrophotographic. If it weren't so expensive, I would buy one just for the experience - but how do you print those negatives?