A good way to import tweets, blogpost, flickr photos, slideshare,
You're on the right track, but it sounds like your site may have some "too many modules" issues.  If you're having modules randomly overwritten or enabling is throwing errors, it is usually time to clean up the site.  If you can, start with a brand new site and only enable the modules you absolutely need.  Keep things as basic as possible.  If you want to try out other modules do it on a separate "sandbox" site that is just for testing.

There isn't going to be a single-solution for all social media.  However some places to get started:


Feeds module - for anything using RSS (YouTube does, so does SlideShare, Twitter kinda does, etc)
Specific modules could be used too like Twitter Pull and the Media module as you mentioned.