Rogue is one of my favourite classes due to their flexibility, in fact of the 6 characters I play fairly regularly, 4 have sneak attack (Though only 2 have rogue). That said, I've never made a pure rogue, all have some dip in something, and some I don't play anymore. (Of all my characters in the past, I think I've had 8 characters in total with sneak attack dice). I've seen a few good pure rogues, I know of one or two that still actively play their pure rogue. Typically, to do any soloing a rogue will need to learn to take some form of defense, be it combat expertise or a shield/armour. Ranged weapons also help alot with sneak attacks, as you can get them within 15 feet (I know a rogue that used to point blank sneak attack people with a longbow).
The first is to give into the cheese and take one (or two) levels of Shadowdancer (that second level can be useful to races that don't get special vision modes).
Shadowdancer is a great way to increase strength, although assassin is available as well (At level

due to HiPS. HiPS though is highly difficult to RP, personally I dislike getting a level of shadowdancer to get HiPS, and opt for the 8 levels of assassin.
Another is building for Feint, though I'm not sure how well it works in general.
Feint is a tricky one, you have to invest in it fairly well to make good use of it. Feint works by taking your bluff skill versus the enemies BAB + Spot skill. If you're fighting an enemy with high BAB, or high Spot, this is pretty much useless. Then again, fighting an enemy with high spot may make your HiPS useless too (Though I've rarely come across anything that can see over 40hide/MS besides players). However, this doesn't make the skill useless. Those typically with high spot or high BAB are archers and fighters. Archers tend to be squishy, and fall quickly to your sneak attack from hiding, or just from plain hitting them. Mages and rogues tend to have low BAB even if they have relatively high spot, so they are perfect targets. Your weakness is fighters, but thats with most rogues, be they Feint, HiPS or other.
I'd be proactively trying to recruit them into the AV simply due to their usefulness in that regard.
Georg Bauer, if he ever leaves the Fleet is a good choice

.
What you will not do as a Rogue obviously is tank, and of course you cannot exercise some of your better tactical advantages against undead and other sneak-immune opponents.
Actually.... I have a rogue tank. They are quite nice. My rogue tank, whom coincidentally is my Exemplar Methos Rift. He also coincidentally is the purest of the rogues, being 90% rogue. He has the ability to do many different things, and I saw rogue as a way to compliment his style, even if it weakened him a bit. Most people wouldn't think that a man with fullplate and a tower shield is a rogue, but the fact that he has feint and sneak attack and disarm and knockdown, well hes a combat specialist not unlike but more RP flavoured then a fighter combat master. And in the end he even manages to get an RP bonus with lots of strong speaking skills.
Oh, and by the way most people hit like a wet rag at level 6, except pure fighter types (Paladin/fighter/barbarian) or clerics. There is a lot of strength in pure rogues with a high amount of sneak attack dice, crippling strike, improved evasion etc.
How many other classes can say they can completely avoid all AoE spells (Monk and Shadowdancer), or lower strength of those hit by sneak attacks (None, but Swashbuckler gets something similar for crits at level 18 or 20) or a feat to bring them back from death (Spirit shaman gets something similar at level 19), or even slippery a reroll of a will save(Shadowdancer, Swashbuckler or some clerics and spirit shamans(Something that for others costs 2 feats)) or +4 to sneak attacks(none)? Even just using it for a bonus feat, it can be used for anything something fighters can't even brag about, giving a rogue the equivalent of 7 feats between 10-20 compared to everyone-else's 3 (Wizards and fighters get feats, but from a special list not from everything).
In conclusion, rogues are great for parties, relatively easy to roleplay (Rogues can do almost anything, from tanking(Like Methos Rift) to spellcasting(Arcane Trickster) to dex (Shadowdancer/Assassin/Invisible Blade/Pure), they help parties by opening chests/disabling traps and they are probably a class most similar to the average human today.