For macro I could understand why you may want it (though the dof gain will be badly offset by sharpness loss) focus stacking seems to be the popular solution (and some people do a fantastic job of it)
For shooting other than macro though (ie landscapes) i can't see much need for more than f22 from a dof standpoint on apsc (maybe 32) light may require it but that is what ND filters are for.
Medium format of course you see F32 commonly and even F64 occasionally because the format may need it for a landscape (large format lenses that go to F128 are about as well) a Tinkerer like Rio Rico would like just use a 80-100 year old large format lens adapted through mad scientist wizardry