There are loads of good schools in the area! Which schools are you in catchment for?
I know families who have/had dc at Torriano, St Patricks's, Tufnell Park, Eleanor Palmer, St Silas, Kentish Town CE and Brecknock, as well as schools a bit further north. All are/were happy. Of those only EP has a micro-catchment, the others are all reasonable, i think, although you can't be in catchment for all of them. I don't really know Camden schools, but can't imagine they're significantly worse than KT.
If you're Catholic and in KT, St Patrick's would be an obvious choice. The current head of KS1 at St P used to teach my dc (at a different school), and is so fantastic I'd pay good money for her to teach my child. St Joseph's is a bit further north, but also a great school.
Primary schools are really not something to get the fear about - there aren't any schools in the area that are truly horrible. There are one or two secondaries I'd be less keen on, but that's five or six years down the line. Don't listen to the people who get obsessed with ridiculously popular schools, and who would have you believe that if you don't get into Eleanor Palmer your child will spend every playtime having his head flushed down the loo by the feral offspring of crack dealers, cos it really ain't so.
And now that Camden have clamped down on people gaming the applications system by means of creative address management, many intake areas have increased. The catchment for Camden Girls went most of the way to Archway last year, which is unheard of in living memory.
Go visit some schools, talk to the teachers, talk to the dc and get a feel for the atmosphere. My dc were at a school which was not one of the ridiculously over-subscribed m/c honeypot schools, and honestly I would not have swapped it for private if I'd been offered it for free. 