‘Normal’ isn’t the most useful word for describing human interactions. It’s always going to be biased by your culture, upbringing and life experience.
A lot of people here are saying that people become more attractive as you get close to them, and I’m sure that’s true–for them. Just to offer an alternative perspective, I find people less physically attractive the better I know them. I still love them and enjoy their company, and I wouldn’t trade them for anything, but I just don’t really want to be physically intimate with them past a certain point. I’m very independent and probably just not cut out for that kind of long-term relationship, but I’m also very open about it when talking to potential romantic partners. I don’t want them putting all their eggs in one basket, especially when that basket is full of holes.