I am a psychology major at a liberal arts college in the Northeast (Amherst). I think a LAC will be your best bet to get extensive research experience as an undergrad - at universities, professors will often have grad students to assist them and don't need/want to hire many undergrads.
Without standardized test scores, it's harder to select schools that might be realistic. But definitely look into liberal arts colleges!
From their website, you seem to be about average stats-wise. I think having applied ED and being a URM will help you. If your essays and recs are good, I think you have a solid chance! Just make sure you have some schools to apply to RD if this doesn't work out.
If "social life" to you means strictly parties in darkly-lit dorms with lots of alcohol, then yes, the social life is built around athletics. There are definitely club-thrown parties, but you may not find one to attend every single weekend.
If you are interested in casual hangouts with friends (with or without alcohol) and in other social events like @OHMomof2 describes, then you will have no trouble as a non-athlete. If the organization you mean is AC After Dark, they focus on providing events for students outside of the party scene -- ice skating, movies, comedians, etc. I think it's a good thing to have lots of options, not a concern.
You're obviously very qualified, but I think it's a bad idea to consider any of these schools safeties or matches. Columbia and Amherst are not "high matches" for anyone. If this is your full list, you DEFINITELY need to add real safeties and matches.
However, I do think you've got a fighting chance, so work hard on your essays!