Ok, so I have attempted to mix different workarounds to get it to work as I need, and I'm almost there, but now have a bigger problem.
#1) So, first thing I did, was backup my XBMC roaming folder which was about 850MB.
#2) Then ran bradvideo's script (
http://forum.xbmc.org/showthread.php?tid=96097&page=6 ), which brought my xbmc roaming folder down to 725MB. It's a start, but not enough.
#3) Cleaned my Library in XBMC
#4) I then went ahead and Exported my library to SINGLE FILES in a completely separate folder on a different drive. This came out to a 15MB XML file, and a bunch of jpg / tbn files.
BUG #1 DETECTED: If my episodes had custom episode thumbnails, these weren't exported, only the defaults were. So for example: for Family Guy, the Episodes like Blue Harvest which have their own dvd, I had a custom episode thumbnail (the dvd cover), this wasn't exported, only the default was exported.
#5) Exit XBMC
#6) Then I deleted my Video34.db file, and deleted the entire thumbnails folder
#7) Restarted XBMC and Imported my library from the 15MB xml file thats now sitting on my separate drive.
#8) Wait ... and then wait some more.
#9) It recreated my Video34.DB file, and started loading all the fanart, etc, back to the Thumbnails folder.
#10) My library was perfect (with the exception of losing custom episode thumbnails on export/import), my Roaming folder now was only 100MB rather than 850MB/750MB (after script)
#11) BUG #2: I went and right clicked a movie, and clicked "GET THUMB" hoping XBMC would now attempt to find new thumbs I can potentially use, it only found the 1 thumb. I no longer have access to any other thumbnails other than the one that was imported... Oddly enough, the GET FAN ART button works. I can change different fan arts, it finds them from the web. To add to the problem, the "REFRESH" button, on all my movies and TV shows is greyed out, and unselectable... (see pic below)
So i know that over 80% of the files in my thumbnails folder is junk that xbmc isnt cleaning, I can get the size down, but then I cant get new pics or refresh my movies... any way to fix this?