Hiya!
IME, the effectiveness of a Rogue is primarily based on how smart the player is. I have one player who LOVES to play thieves...but she absolutely sucks at it. It's amazing to just watch her make decisions on how to overcome something "rogue'ish", because they are almost always..."bad". I have another player who prefers wizard-types, but plays Rogues on occasion. He plays them almost too well. He uses "the campaign world" far more than he uses any specific rogue ability. He builds contacts, he has custom equipment designed, he seeks out mundane items to help him pull off a heist/job/whatever, etc. In a dungeon, he does the same thing, but uses his abilities more (obviously) to help do all that stuff that makes trying to infiltrate a thieves guild so dang dangerous! (setting up traps/deadfalls, covering trails or confusing them, etc).
So, as I said, in my experience the capabilities and success of a Rogue is VERY much up to the Player and not the abilities written on the sheet. YMMV.
^_^
Paul L. Ming