There are a couple of pedestrian bridges withing the grounds of UCC too - one at the Western Road gates and the other linking between Aras na Laoi and Castlewhite. Neither bridge is particularly inspiring. I found a picture of the Western Rd Gate bridge on the web. No luck with a search for Castlewhite.
Indeed, the College Gates Bridge is a fabulous piece - definitely up on my top list. I love the ornate detail. Oddly, Cork once homed many such bridges - the former North Gate Bridge was a magnificent structure with copper edging, lamp-posts, ornate engravings - the works! It's a pity its predecessor didn't even make an attempt at resembling the former...or even to attempt resembling a bridge!!!
I personally think Shandon Bridge is over-hyped - I admire the timber walkway, and some of the lighting is most pleasant, but it gets a lot of talk. The Wain Morehead design was far more unusual.
As for the 'Pink Link' - its a love/hate kind of structure. You can look at it from an economists perspective and get a heart-attack, or an architectural perspective - and well, make of it what you will. It's an open debate.
And yes, there are plans for a Merchants Quay/Patrick's Quay pedestrian bridge - but its a few years off yet, at least.