Rudy's is nice for getting hammered alone in peace and quiet.

Owl shop can be nice.

Archie moores and Chris Martin's in East Rock

You will meet people at geronimo/bar/crown street but they will be awful

If you want to make friends in the bar scene I would suggest getting a part time job there...