I've got 2 offers for a tenure-track position (computer science). One at a well known "tier 1" institution and one at an institution that would be considered "tier 2", both in the US.
Most people I know in academia would immediately go for option 1, considering it a great opportunity. While I do agree that this would look great on my CV, I'm somewhat cautious due to reports that tier 1 institutions are very reluctant granting tenure to anyone who doesn't find the cure for cancer...
I'm well aware that getting tenure at a tier 2 institution won't be a field day either, but looking at their previous record, a high percentage of assistant professors at that institution did make the cut.