Yes, I agree.
But, in many (if not most) situations the ms you loose by doing more round trips then necessary are not worth how much more maintainable the system is.
Especially when there is probably some programming or query optimization that will save you seconds, when reducing the round trips is a matter of ms.