enums and check constraints require DBA involvement to make changes, whereas adding a new entry to a lookup table falls within user purview like any other user data
yes it would make a difference which database system you use, as they handle these things differently
mysql, for example, does not support check constraints, and the enum syntax in postgresql is different (other database systems like ms sqlserver don’t support enums at all)
~all~ database systems support tables, though