I quite like the petrified forest in Victoria Park because, well, no one expects a petrified forest in Glasgow!
For actual *stuff* though, has to be the Kelvingrove. Transport museum is also good, they have the actual BMWs from"Long Way Round" (don't recall seeing the weird Russian thing Claudio ended up on).
Really need to go to the science museum at some point.