Trinity is exceptionally prestigious, very beautiful, very rich, very highly regarded with some good people and great accomodation so yes that one I'd rank top.
King's is probably second, very alternative, awesome mingles and the affair is unbelievable. Really nice people. They host some of the best club nights in Cambridge, although the accomodation is a bit too scattered and I don't find it that pretty.
Pembroke, Downing and Clare are all pretty but fairly non-descript. Clare has nice first year accomodation but, all three of them are just so placcid. Although if your a scientist Pembroke and Downing are fairly convenient. But i'd much rather be at John's and have to walk for 5 minutes more....