I legitimately don’t understand why a lookup table is ever seen as adding any meaningful amount of complexity.

    SELECT a.foo, b.bar
      FROM alpha a
      JOIN bravo b ON
        a.id = b.alpha_id

The speed hit from an INNER JOIN on indexed columns is negligible, and will be dwarfed by network overhead for most places. As to flexibility, if you need a new value, insert it.