I believe that every mood would make for better writing depending on the subject matter. Some of the most artistic pieces ever created were those coming purely from pain or joy. Being in a good mood could help get you into a "flow" as well. So I'd say yes. This doesn't mean only write when you're in a great mood though!
You can help the HubPages community highlight top quality content by ranking this answer up or down.