The reason Rogue player experiences vary wildly is because DMs vary wildly in the opportunities they give Rogues to shine with their skills. They are competent contributors in combat, but if there aren’t any chandeliers to drop or MacGuffins to steal they won’t get true spotlight moments.

All the best Rogue moments in my campaigns have involved theft/replacement of MacGuffins or opening locks/freeing prisoners while under fire.