As the clicking and not starting, I would think you either have a weak
battery or a weak starter. You may have corroded connections. Also some
Honda starters have replaceable contacts that can get rid of that problem.

The sunroof leak is probably caused by plugged drain tubes.

As far as your wipers are concerned the chart in the service manual would
make me consider the wiper control unit or the motor, or both.

The fuse blowing for the horn is probably a bad horn. If you have an L or
LS one horn is in the engine compartment, by the left fender. The other is
in the bumper on the right side. If you have the STD model, then both horns
are in the bumper. Assuming that the horn is the problem, should be able to
disconnect one and honk to see which is bad.

>
> On another note, my Legend has been giving me some other misc.
> problems lately. The sunroof leaks when it rains. The windshield
> wipers don't work in intermittent mode and don't retract themselves
> when you turn them off (you have to sort of time it). When you hit the
> horn it blows out the fuse every time (which is also the fuse for the
> break lights). Any suggestions for any of those odd problems would be
> appreciated.