Try starting a thread about "10 greatest basslines" over at talkbass.com, and you'll very quickly get pointed to people doing things with basses that you couldn't imagine were possible.
Victor Wooten can do this stuff without any effects - just fingers on a bass.
This takes until about 1:00 to get going - but for the folks worried that Metallica's bassist is being "wasted" in that band (which is totally true) - this guy was the bass player for freakin' Whitesnake for a while. Now that's a waste of talent.
I've always liked the funky beat to Pink Floyd's Have a Cigar. I think it's a great bassline opening to a song, that's for sure.
Slightly off topic and completely useless for rocksmith since the song has such an array of instruments, but while its one of my least favorite Paul Simon songs I've always loved the nasty little bass riff @3:44
I love Victor Wooten for his ability. I saw him a long time ago with Bela Fleck and adopted him as my bass idol. But most of the times I see him he's making these impossible riffs that are also impossible to like, it's my gripe with the kind of jazz music he plays for the most part. Riff all you like but I need a melody in there somewhere. Lots of ugly sounds to me. That video as really good though, until the later parts.
Here's a link to what I think is the highlight of the SMV album.
I'm gonna have to go with two classic Beatles songs.
I used to go to Talk Bass, but all I would ever hear is Jaco this or Wooten that. Ever try sitting around listening to either? Not my cup of tea. Give me some Primus if I want my mind to be blown by bass. I have not gone at the site for at least a year, but if you are new to bass you can learn a ton from those guys. Mostly about Jaco.
http://orckiller666.blogspot.com/ <---- The Orcs will not win.
La Villa blows me away every time I hear it.
Didn't someone say recently here that Rush was "only big in Canada". Hmm lot's of non-Canadians mentioning them in this thread....