The Web Map Gallery managed by Directions Magazine is a rich resource to show what others geospatial professionnals have created. For example:
KOLKATA
10 December, 2008Category: Retail
Industry: Cartography
Brief Description: MAP OF THE CITY OF KOLKATA, WEST BENGAL, INDIA
Server-side technologies: ARCIms
Server-side applications: arciMS
Commercial GIS Software used: arciMS, arcgIS
Time invested in development: 3 YEARS