Sorry for the potentially controversial question: is it normal for less attractive people to settle down with partners they don't find physically attractive?

'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.