There are a lot of options with rogues and what you go with will depend on the DM, options allowed and the group.
Arcane tricksters are a lot of fun and can, depending on what you need, be quite flexible. One of my first 5E PCs as an arcane trickster, it was a lot of fun. Took a little more creativity though, since your spell selection is limited which in part depends on the DM. Having an invisible mage hand was a blast at times.
Not sure if it's an option though.
While I haven't played it, the thief is pretty straightforward.
Other than that? You need to think about what kind of rogue you want to run. Throwing daggers can be fun (and I'd consider going 2 at a time) but your range is pretty short. Depending on your DM a lightfoot halfling hiding behind allies could be pretty devastating. You don't need to attack from hidden to be effective but it doesn't hurt. A shortbow is better if you want to snipe from cover, but again I don't know how often that will be an option.
My wife's PC in my current game is a swashbuckler, she really enjoys annoying me by running up, stabbing and running away without having to use her bonus action to disengage because it let's her use her bonus action for off-hand attack if the primary misses. I guess it's fair trade for my rogue PC that she had a hard time hitting once he got shield.
Being a good investigator is simple - that's what expertise is for. Inquisitive does seem to be a good option for that.
Anyway, those are my two coppers. I have them right here ... wait where did they go? I swear I had them!
Arcane tricksters are a lot of fun and can, depending on what you need, be quite flexible. One of my first 5E PCs as an arcane trickster, it was a lot of fun. Took a little more creativity though, since your spell selection is limited which in part depends on the DM. Having an invisible mage hand was a blast at times.

While I haven't played it, the thief is pretty straightforward.
Other than that? You need to think about what kind of rogue you want to run. Throwing daggers can be fun (and I'd consider going 2 at a time) but your range is pretty short. Depending on your DM a lightfoot halfling hiding behind allies could be pretty devastating. You don't need to attack from hidden to be effective but it doesn't hurt. A shortbow is better if you want to snipe from cover, but again I don't know how often that will be an option.
My wife's PC in my current game is a swashbuckler, she really enjoys annoying me by running up, stabbing and running away without having to use her bonus action to disengage because it let's her use her bonus action for off-hand attack if the primary misses. I guess it's fair trade for my rogue PC that she had a hard time hitting once he got shield.

Being a good investigator is simple - that's what expertise is for. Inquisitive does seem to be a good option for that.
Anyway, those are my two coppers. I have them right here ... wait where did they go? I swear I had them!
