I think this is a very individual thing, and different schedules work best for different people.
If what you are doing isn't working, by all means change it. If that doesn't work, change again
For me, I want and need to weigh myself every day. In the beginning I did have to sit myself down and give myself "the talk". "No, you did NOT gain 4 lbs over night. It IS water weight, now get over it".
I found graphing my daily weight in Excel, then creating some formulas to average my weight loss over a week, two weeks, and one month really helped. I paid less attention to the daily fluctuations, and more to the weekly ones.
Why I don't like weighing less often. What if I weighed myself one month and I was dehydrated and weighed x. The next month, I had been exercising a lot, ate a salty meal the day before, etc. My weight might be up 1 lb, but I could have actually lost as much as 3-5 lbs. Without any other weight stats to look at, THAT would be hard for me to handle.
By weighing daily, I can track trends, I also keep a notes field in Excel which documents pertinent data regarding food and exercise - things that may affect the number on the scale.
But again, do what works for you!!!!!