Going to a very good program at a LAC will be a good experience. As it will at a “national university”.
Going to a poorly supported program at a LAC has a grater chance of a poor outcome. As it will at a “national university”.
The label on the overarching institution has little impact, IMHO. Businesses hiring graduates in a specific field, or graduate schools evaluating applicants, know the quality of the individual programs.