Dependent Dropdown Field Type

This is quite a long topic with many replies, but I’d be interested to know if the relation filters that were released recently can solve some/most/all of the use case?