How do you give feedback to a superior who is excited about a brilliant idea and eagerly wants to hear you agree?

I would make it your goal to see how your superior’s idea could work. Work with him/her and work through any inherent problems. One of two things is going to happen: You'll get sold on the idea that it may actually be brilliant OR your boss will lose excitement because of any unfixable inherent problems.