Brooklyn vs Manhattan??

Hi everyone, I'm a 30 year old female, wanting to fulfull her dream of living in NY. I grew up in Austin, have lived in DC the last 9 years and am finally wanting to make my way to the City. Austin is a young, funky and liberal town that has in many ways shaped who I am, and DC has been fun, but a little too "buttoned up" for me. I am looking to experience the buzz of NYC, diversity, food, culture and excitement. Lately, it seems that Brooklyn is all the rage, but a piece of me feels that I'd miss out if I didnt move to Manhattan. Is this a false conception? Trying to decide between an apartment in the Village or a place in Bushwick (or any other hip spot in Brooklyn). For a 1-2 year stay in NYC, where would I get the best experience? Any thoughts would be appreciated!