I have my news broadcast set to play every hour, however on a weekend I have a couple of shows where I ideally don't want the news to play. Is there a way to basically say "play this event every 60 minutes apart from 8PM-11PM” for example?
Yes, this is possible - set the event start time to 8PM, enable the "Repeat every" feature, set 60 minutes period and limit it to 4 repeats.
Apologies again as I feel like I'm being a bit thick here, but I'm struggling to understand the different insert type options in the scheduler even after reading the guide a couple of times. In what cases should the different options be used for?
It depends on what you want to achieve.
"Replace playlist" will clear the playlist window completely and load the event, this is typically used when you switch playlists e.g. between morning/day/evening so that you're sure there's no unwanted tracks left in the playlist. "Queue after playing track" will simply insert the event after the currently playing track. Can be used for station IDs, for instance.
"Replace scheduled tracks" will remove other scheduled tracks from the playlist but will leave regular tracks. Useful if you want to interrupt some scheduled show and play something else.
"Queue after scheduled tracks" will queue events one after another - you can have multiple TOTH events that are scheduled like 1 second apart, :00 starts the TOTH jingle, the :01 event starts the news, and using this option you can queue those one after another.
A feature that recognizes and automatically deletes duplicate uploaded tracks would be great. Because I have accidentally uploaded some tracks with me several times and thus lost some of the overview.
Checking for duplicates based on file name is not reliable (there can be multiple tracks with names like "Track01.mp3") and may give lots of false positives. While checking if the actual audio content is reliable but is too resource consuming, so technically this is not a good thing to add.