As an international student who has always longed to experience the cultural diversity America has to offer, Yale’s location in New Haven, the cultural centre of Connecticut, will enable me experience that cultural diversity.
Consequently, the specialization of Yale’s Psychology program in research of clinical psychology, among others and the musical resources such as The Irving S. Gilmore Music Library, The Fred Plaut Recording Studio and The Shubert Centre for Performing Arts, that Yale and New Haven provide will make it possible for me to pursue my passion for a Psychology and Music double major.
Awkward wording/excessively long sentences throughout.
Good idea though!
The 1st paragraph is one super long sentence. The parallelism is off. If you simplify it, you'll find that your sentence says: "As a student, Yale's location will enable me experience that".
The parallelism is fine in paragraph/sent 2, but you should cut it up into shorter sentences.