It's not nearly as bad as people make it out to be, obviously not as good as RE4, but few games are. All 3 campaigns are selectable separately, but the total story revolves around all the characters, so you'll have to play the entire game to get the entire story. There's 4 campaigns, one for Ada as well.
Give it a go, no harm in trying it out.