I agree that UIs should also fight to diminish the visibility given by bot upvotes if they can, but it's not easy as it requires each UI to have it's own separate db to query and sort in the way they want

Sure but the hot and trending metrics are not blockchain-level metrics anyways? It seems like ultimately it's best for layers on top of the blockchain to run algorithms to identify the right content for a given user.