The majority of spells one could think to cast are listed in the rules.  If you want to do something different (like the confetti) just PM me or ask in OOC.  Usually the DC will be a 6 or 9 for something light.