Is this consultation only for large projects?

No, it's useful for jobs of any size — the value is in avoiding a mismatch, which can be just as costly on a smaller job as a larger one relative to its budget.