Marshall Breeding has done a survey of librarians to find out how satisfied they are with their current ILS software and vendor (summary: it varies) and whether they would consider an open-source alternative (summary: not so much).
Here are the survey results.