Weston-super-Mare's See Monster is now closed, but was it a success and what will be its legacy?