I'm in my 2nd year at leicester now and i still cant fault it! Good teaching, good sports teams and societies, decent night life etc. I needed ABB to do my course so its not like you can just walk into this uni it actually requires a bit of intelligence and hard work to do so. I do geography (make your jokes) and one of my lecturers in the first year was one of the authors of an A-level text book i used (i think it was for OCR).
I think one of the best things about the uni is that it has relatively large (and well established) department areas, some unis dont have large departments for certain courses which can limit their available facilities as many subjects are not purely based in lecture theatres.
I'll have to use geography as an example cause its what i know best; i looked at a few different unis when i was searching and found that some places that offered my course, didnt have an entire department dedicated to it, it was more like a few classrooms and lecture theatres in the back of some random building. Obviously im not saying leicester has a building for every subject and course but i feel it has a good wide range of facilities that can satisfy the majority.
In terms of prestigiousness, its not like a cambridge or oxford but what is? Leicester's motto is something like 'elite, not elitist', so you are at a very good university but you are with a very level-headed and like minded group of people who enjoy their respective subject area and have a good knowledge about it too, as well as wanting to go out with friends and have a good time.
So is Leicester good? Yes
Is it prestigious? Im going to say No
But hey, who wants to be at a super prestigious place anyway? most of the time it just goes straight to the students heads.