Hi OP,
Did your dd look at Churchill College www.chu.cam.ac.uk? It's my old college (I was there 20 years ago!), and I loved it. It's extremely strong for subjects such as science, engineering and maths. When I was there, it had approximately a 75% technical subjects bias and a 75% state school intake (around 75% male as well).
It has 485 undergraduates, just shy of your desired 500.
There is no kitchen fixed charge, and you pay for the meals that you buy. I hardly ate at all in hall after the first term, because I didn't like the food. We had a kitchen per staircase with a 4-ring electric cooker with grill and oven. Excellent library and tutors, particularly in the technical subjects. We had the most computers at that stage as well
. My department was at the other end of town, so I often used to sit on the wall at King's at lunchtime and people-watch. Some of my classmates were from Caius and had meal tickets to use up, so they used to treat me to lunch as well.
We are all in our normal clothes at matriculation photo, the porters told me that we had done nothing to deserve to wear a gown at that point. I only wore a gown on graduation day. I don't think we ever had tourists as it was off the tourist trail. We had conference guests as the college has a conference centre, but we didn't really see them. The Master (Sir John Boyd) was absolutely lovely, and invited us to his lodge to have dinner with Yehudi Menuhin when he came to speak (that's one of my most treasured memories). I kept in touch with him after I left, as I still had some connections with the college through work.
I have a handful of friends from college, mainly those with whom I studied a subject, and those of us who came from the same part of the country. Most of my other friends are from my subject and the societies which I used to be part of.
I can understand your dd's concerns. It is tough and intense, and people do drop out from stress. One of my friends dropped out in the first term and completed his studies at Birmingham, where he thrived. I think that if she would struggle with the thought not being one of the top achievers in her cohort, she might find it difficult. I always said that Oxbridge was very good at taking me down a peg or two, because I went from top of year to distinctly mediocre very quickly!
My younger sister got the grades for Oxbridge, and had straight As and As at GCSE, and straight As at A-Level (I don't think they had A grades at that time). She chose not to apply after visiting, and my parents were very disappointed. I am sure she made the right decision for herself though.
I do feel very lucky and privileged to have been able to study at Cambridge. A pp said that if you look for a certain type of person then you will find them - I agree with her!