Better to succeed at a lesser known college than suffer at an Ivy?

If any suffering is making you work harder, gain new skills/knowledge, actually improving your personality, then go for it. No pain no gain.
But, if the suffering is making you miserable day by day, then don’t go that way. It’s not worth it. Choose the other option.