I would say that you appear to be suffering both the advantage and disadvantage of the current h&s system. Instead of being prescriptive as much of h&s used to be, h&s law is now risk and objective based.
As you are no doubt now aware there is a legal requirement to conduct risk assessments - either spcifically under DSEAR/ATEX or COSHH legislation or the general requirement under the Management of H&S regs.
However, what you then do and what is proportionate to the hazards/risks of your business is then open to debate - as you have seen from the various reports you have at your desk.
Sadly nobody can be an expert in every h&s topic, which maybe partly explains the differing opinions you have as well as the obvious limitations of each persons area of knowledge/experience.
My main area of interest is DSEAR/ATEX - of which the HSE guidance L138 ACOP tells you what the regulations apply to and what you must consider under your risk assessment. However as previous what you then do depends.
If you do undertake painting with solvent based paints - do you spray paint or is it just hand/brush painting? Its imperitive that the process is understood. The controls for spray painting are very different to relatively low risk hand brush painting.
I'll stick my neck out - if you are in a small industrial unit and only hand painting - then provided you are in an open area with 'normal' venilation such as open doors/windows etc then any hazardous area is likely to be less than 1m. Therefore it is unlikely that you need special tools/electrical equipment (ATEX rated electrical equipment is only required if it is used inside the hazardous area).
For such small scale use it would be expected to see a 'flammable' storage locker in which to store paints/sovents, to a limit of 50litres. The locker should have at least 30minutes fire integrity.
Other containers used to hold paint etc should be sealable/original containers and not fragile.
Ignition controls are the obvious - no smoking, no hot work nearby etc as part of your safe system of work
Paint spraying would be different - as obviously the paint vapours are likely to travel over a wider area. Working indside some form of enclosure is usual, with lighting mounted outside the enclosure where possible - otherwise Zone 1 lighting is likely, as usually all of the enclosure is likely to be a Zone 1 hazardous area.
Key guidance are HSE publications L138 Acop, HSG140, HSG51