Clanbrassil Street area
I've lived in a little house just off Dean St / Patrick St since 1997. I suppose the fact that the street is not a cul-de-sac makes a difference, in that there's always a car driving up it, or people walking up or down.
But I have NEVER had a bad experience there. The residents are friendly, with a good mix of some of the older families who have lived there for generations, and younger blow-ins.
As others have advised, suggest you go there late at night before buying, see what it's like. I also agree a house is better than an apartment - not least of all as it may hold its value better!
Best of luck with your decision - I find there are huge advantages to living so centrally, and love being part of the inner city.