Filter using relative date values ("TODAY" etc.)

Agreed. The obvious use case being able to filter Deals with a close date in the past

(i.e close date before “Today” with the value of Today changing dynamically not needing a manual change)