I’m a bit curious why you applied to Hamilton. Did you visit the college or research its location? If you do not want a rural environment and are looking for a vibrant college town, why apply to Hamilton in the first place? No one who has done even minimal research on the college would think it would meet your requirements for anything other than academics. There is much more that goes in to choosing a college that is the right fit. Since you are looking to transfer, I suspect you already know that.
Given the nature of your non-academic desires, you should go to Smith.
Edited to add:
(By the way, D20 applied ED to Hamilton and was thrilled to be accepted. I am not suggesting Smith due to bias. I just don’t understand why students who want to avoid a rural location and have easy access to a vibrant college town, choose Middlebury, Hamilton, Colby, etc. and then complain that they are “stuck in the middle of nowhere.”)