I’ve never truly used DISTINCT and felt comfortable for using it. Always felt using it revealed a design smell in my query. (Been doing SQL for 30 years and still!)
Theres very few cases where you shouldnt be doing a group by with aggregates instead. (window functions count here)