Yes delta is primarily used for OLAP type applications. Web apps typically would use a high concurrency transactional database i.e. OLTP. That is why you would likely want a transactional database.

If you are looking for an analytics system then use Databricks + Delta Lake. This is a single platform for all your BI and ML needs. With traditional data warehouses (Snowflake, Synapse, Redshift) you are only looking at BI type workloads. Delta allows for all the DW features but on top of your data lake. I would suggest not going with a data warehouse because it will reduce your total cost of ownership and enable your team. Going with a Lakehouse as it has better support for more advanced data use cases.

Delta performance does not degrade as versions grow because we maintain specific transactions as well as snapshots of the data. Check out this blog that describes in detail how delta works.

Are you looking for a new analytics stack for your team?