Unlike just about any other ship I can think of, Daniel/Sha're makes the story happen. If he wasn't completely in love with her and then she taken by Apophis, he might not have left Abydos and hence no awesomeness that is OT4 SG-1. The resignation scene from Daniel's dream during FiaD supports that I think.