It’s worth noting that DATE, DATETIME, TIME and TIMESTAMP are basically identical in the functions they have, as you have roughly shown. So you really just need to remember the basic structure, e.g. CURRENT_XXXX, XXXX_ADD, XXXX_SUB, etc. and it doesn’t matter what data type you work with.

Also, adding in my favourite recent ones: GENERATE_DATE_ARRAY and GENERATE_TIMESTAMP_ARRAY for easily creating indices!