Years ago (pre 2007 so may not count as mortgage rules very different now) I got a good deal from BM solutions (www.bmmortgages.co.uk) with much worse credit than a single CCJ.
They only deal through intermediaries according to their website but give a link to brokers who use them. Platform is a subsidiary of the co-op and also do what is known as non-conforming mortgages. Not a recommendation obviously and there are other providers.
I would read the information on moneysavingexpert on mortgages and talk to a mortgage broker but make sure they screen for CCJ acceptance. When we saw ours, he had a software package that he put the details in and it filtered for mortgages that we qualified for. The lenders make their criteria available to intermediaries so they should know who will and won't accept you.
Your IFA doesn't sound very good appropriate to your needs. There is absolutely no need to pay for credit file information these days. You can get it all for free via moneysavingexpert. Also be aware that credit scores are fairly meaningless and all lenders assess borrowers according to their own criteria.
He shouldn't be putting random applications in with lenders either. The whole point of using a broker is to find one who will accept your circumstances, including what sounds like a minor credit blip, without wasting applications and trashing your credit file.
If you don't have perfect credit, then it is likely you will pay more interest but it won't necessarily be ridiculously high and as a PP says, it is likely that you will be able to remortgage onto a standard product in a few years time. You might not even have to wait until the CCJ drops off your file, just that it is 'old enough'.