I agree with majority of your points, and defintely the SQL with direct joins will be more efficient.

But I see a niche for the USS for small to medium size and complexity solutions as additional layer targeted for business users that don't want to write SQL queries, but rather use Self Service capabilities with drap-and experience.

Big Data Architect & Data Warehouse Expert at SoftServe Inc.