I can only recall hitting the limits on movements once. This was a 90mm on a 5x4 Wista picturing a crane, where I was backed right up to a fence. I just had enough rise, but the bellows was protesting a bit... Now the MPP technical just wouldn't have had the movements at that focal length. This was exceptional, though.
I have 'failed' some shots by not being thorough enough when using movements - being too fixated on fixing the problem area and not paying enough attention to where the plane of focus would intersect elsewhere.
If I am out with a rigid body camera I find I limit myself to what is possible within that constraint. With a flexible body camera I tend to look for things where movements make a possible image, and ignore the straight-on approach. I think I need to get over that 8-)