So i've got a bit of an update.
After getting so fed up with this ongoing issue (it's been over a year). I took my iMac (mid 2010 27") into apple for them to look at. They said there was no problem with the machine after their tests. However the issue still continued with my Drobo, other external drives, printer etc. continuing to eject.
I finally bit the bullet and purchase a new fully specked out 5K 27" iMac, as my old one was getting slow (i'm a professional photographer) and in the hope that it would resolve the issue.
Guess what?
It didn't.
In fact it was even worse as my Drobo was now plugged in via USB 3 rather than Firewire. So every time the computer went to sleep i'd come back and the hard drives were ejected, the printer, my Wacom tablet and even my wired keyboard. This meant that I had to restart the computer as I couldn't put my password in. ARRGGH.
I tried various combinations in the hope that it was one of the hard drives which was doing it. Just the Drobo on it's own. Still doing it. The Seagate and the WD drive. Still doing it. Just the Seagate drive. Still doing it. So it wasn't down to the external hard drives. I was worried that it had contracted some sort of dodgy software virus.
After almost 5 hours on the phone to apple HQ in California, I've now been told that it is 100% an issue with the Apple OS. Apparently Apple are aware of it and are looking into the issue, but have no timescale on fixing the fault.
So what is happening, is that when the computer goes into sleep mode, it shuts down something to do with the USB ports, which in turn ejects the external hard drives, causing a 'sleep wake kernel panic'. Which can cause the computer to restart. Which was happening to me loads.
They have recommend a work around for me though. Which is to go to System Preferences>Energy Saver and tick the box for "Preventing the computer from sleeping automatically when the display is off". I've also unchecked the box for putting the hard disks to sleep when possible.
We've set up a screen saver to come on if I leave the computer for a while. And the last thing we did was to go to System Preferences>Desktop & Screen Saver and set up a Hot Corner for the bottom right to 'Put Display to Sleep'.
I was told to avoid going to the apple menu and putting the computer to sleep that way and if I want to put the screen to sleep and not the computer to use the hot corner function as there is obviously an issue when the computer goes to sleep.
So if I need to leave the computer over night or for long periods, i'll just shut it down rather than going to sleep. It's a right pain, but no where near as much as having the hard drives, printer, keyboard etc. ejecting and having to restart anyway.
So i'm not quite 24 hours in yet of proper use, but it seems to be working (fingers crossed).
I hope this is of some help to anyone who is having this awful / annoying / soul destroying problem. And lets help that Apple manage to find a solution soon.