3D Warehouse is a website of searchable, pre-made 3D models that works seamlessly with SketchUp.

But just like 3D Warehouse, SketchUp has a vast array of third-party extensions to remedy most of its limitation. Want to make pipes and sphere without spending 30 minutes? Get the VBO extension.