The power of Streaming Tables is that you can more easily do Streaming + Apply Changes (Deletes/Upserts, SCD1/2) without having to reason with "how it is done". So this may make it more appropriate for Bronze/Silver and then you use Materialized Views as your Gold Layer because it's likely your consumption layer is a "join" of multiple dims/facts that you present in some cleansed/aggregated fashion for your Gold consumers.

There are definitely customers who use ST's in Gold, but I think Materialized Views are a better fit for a general consumption layer. You can then take it a step further with Metric Views (Business Semantics) when you want "BI-friendly" dimensions and measures you want to enable for your analyst personas.