The trick to playing a rogue in small parties is to maximise the AC (high DEX, Feats/class features, magic) and take the Arcane Trickster as a specialisation. That way you can be a second-rate fighter or mage when required.