My thumb rule for when to use the 45mm SR is simple. If stuff in the frame aren't moving - photo-stack. so usually 45mmSR gets used in landscape where there is a relatively flat foreground and elements of the foreground are moving - for example plants, flowers, insects etc which is extremely difficult to photo-stack. That said, I do sometimes use the 45mmSR if i need to push some pesky objects to a blurry grave ;-) . apart from Macro and Landscape, the 45mmSR is brilliant when used for portraits, although now-a-days it is a bit cliche.
Yes, when properly aligned, the 45mm SR does get everything in focus as long as the foreground is relatively flat (in horizontal or vertical dimetion, as you tilt sideways as well) , OTOH, no one can stop us from Photo-stacking several Tilted images - the stacking software doesn't mind
, for example if we have field of wild flowers with distant mountains + one lovely tree trunk with a nice texture on either side of the frame, I first tilt for get the flower fields in a frame (with blurry tree trunk) then keeping the setup in the same position, click another picture with a tilt favouring the tree-trunk. 1+2 photo-stack - usually a better picture. IMHO one needs to per-visualise how the lens and stack-combinations come together, lest the entire effort ends up in the bin (yup, several hundreds of mine).
Hope this help and happy to answer any other questions