It seems to me that the licensing situation—you have to lease a whole machine for a minimum period of 24 hours—will make the Mac Pro a poor choice in most contexts. The Mac Mini at or near its base configuration may remain the most sensible option.
I wonder how "usage" is defined here: for instance, if I run a managed service on a fleet of Macs in the cloud, which serves many end customers from each machine, is this allowed under the terms?
IANAL (and haven't read the full EULA) but probably. The 24 hour restriction seems to apply to leasing. I would assume that running a multi-tenant managed service (or, for that matter, serving web pages) from a Mac would not be seen as leasing.
Not necessarily. A Mac Pro would work well for single-tenant usage where you want to run a series of applications that can each burst to the whole machine but not take long to finish.