Yes,"love at first sight" is pretty uncommon.And I often heard it is rare to make such relationships last long(but it is posible).And,often,it is very passionate.
I was disappointed,sometimes,when I understood clearly my partner got what he wanted,and is not interested to start a true relationship after it(but I knew it was the risk,if I "gave myself" too soon);but,mainly,there were good experiences.