unaccent() and similar modules definitely seems like something that should be a plugin for those who need it, rather than built-in. It would be nice to have a plugin store to easily install these things.
It also occurs to me that url slugs are a significant use case for unique field constraints:
Either by not allowing copies, or automatically appending “-2” to the end.
I suspect I will need to implement this with webhooks for now.