I do have an Azden WR-PRO wireless mic, however I've found it's audio quality is not that great. I only use it for location shoots where the Rode is not suitable.
I also have a sony wired lapel mic, but once again the quality is not great.
Yes, unfortunately, like I said, a good wireless system is not cheap and the Azden (I had one) you have is very noisy and has a poor mic. I do not know what Sony wired mic you have but I know that Sony is not highly regarded in the pro video world. I have this mic system as one of my wireless setups:
http://www.bhphotovideo.com/c/product/68056-REG/Audio_Technica_W88_24_829_W88_13_829_Camera_Mountable_VHF.html and it is far better than the Azden. I use this when I need extra mics and don't have enough of my other (much more expensive) wireless systems left to use. Another alternative is a mic from this guy:
http://www.giant-squid-audio-lab.com/gs/gs-micline1.html . But I don't know exactly which setup he has would be suited to your camera.
I find lapel mics a real pain, you have to set them up, and can get all sorts of introduced sounds when you move around a lot as I do.
One of the bigger problems with some lapel mics is the cable picking up cable rubbing noises as you move around. Some are much better than others. Again, it is usually the lower end mics that suffer cable motion pickup than others. And yes, setting a lapel mic up properly can be a pain and I understand the wish to avoid them from that perspective.
The shotgun is just much simpler and better for the workshop. There is a lot to be said for no fuss simplicity.
Lapel mics aren't magic I'm afraid, and a wired lapel would be a PITA in the lab I think.
But if you have any suggestions then I'm always open.
Dave.
Of course there is no magic, just better suited gear for different situations. The biggest tip for micing is get the mic as close to the subject as possible. So what I might suggest, given your preference to not use a lavalier (lapel mic), is to get a cardioid mic and have it mounted on a boom right over your head just out of camera frame. You could also just hang it from the rafters of your shop. If you can halve the distance between the mic and your mouth you also will halve the background noise and room sound. You could try just hanging your current RODE mic that way too. Anything more than this gets into hundreds of dollars and probably not what you want to spend.
I am just being picky. There is nothing really bad with your setup, just being a nit picker.