For engineering, short of a few schools. Not so much. I wouldn’t, for example, say Smith is prestigious for engineering. Not WPI or GW, nor Tufts, fine as they are. Prestige is in the eye of the beholder. But top engineering schools aren’t necessarily the top U.S. News overall.
Think about it. you’re going to invest hundreds of thousands. Be where you want to be?
There are motivated and non in every major. That said, few can make it out of engineering if not motivated, regardless of school name.
Btw you are going to school - not your parents or friend group.