It’s not a horrible database, but it’s just expensive and pretty much never a better choice than Postgres or other OSS dbs.

There are certainly some very niche use cases where you need it, but there’s a reason why tech stacks don’t use sqlserver. I think there are better ways to handle durable transactions and redundancy than using sql enterprise with sql‘s replication.