Audit/versioning columns for your db tables in your schema. Yay or nay? What other recurring tables/columns do you use?

Just a generic question.
Do you guys add audit columns to all your db tables?
Columns like created_on, created_by, modified_on and modified_by.

I tend to do it even if the project is small.

Do you have other tables that accompany you through all your projects? Do you have your own DB framework? i.e I always use a table called status that holds all possible statuses of records. (active, marked_as_deleted, inactive, etc)