I have no idea why you couldn't use a rogue for dual weapon stabbing. You only get one sneak attack per turn, but since rogue is not a martial class and does not get additional main attacks, using dual weapons gives you two chances of scoring a hit and thus getting a sneak attack in.
I understand that the recommendation of always hiding before attacking gives you an advantage on your bow attack, which means two rolls and so two chances of scoring a hit. But that's the same two chances that you'll get with dual wielding melee weapons. If you like the idea of a melee rogue, just play that. It'll be fine.
None of the rogue subclasses is especially good in melee combat, but none of them is bad either. Darkweaver gets proficiency in poisoner's kit if you don't have that already. It also helps with ranged attacks from high ground, and while that's not what you didn't want to focus on, it can still help in certain situations. Thief subclass gives you more flexibility by using items with your bonus action, so you can drink potions or poison weapons and then use your main action for attacking.
The rest of your party can be pretty varied, but usually it's a good idea to include one healer (cleric or druid) and one arcane caster (wizard or sorcerer). If you really don't like casters, you can use paladin instead of a cleric so you have more melee power and still some healing potential. Wizard is your best access to 'identify' spell, but you can always carry unidentified items back to town and pay merchants to identify them or pick Insight domain for your cleric (they get identify as a domain spell). If you do not want use an arcane caster, just choose another class that deals high damage, such as ranger or barbarian.
In any case, one or two other characters in your party should be able to stand in melee. That's because your melee rogue can get sneak attacks on enemies that are adjacent to one of your other characters (think of it as flanking or distracting the enemy). You can also get a sneak attack if you have advantage on your rogue's attack roll, but as you can't really hide in melee range, that requires more set up. (This is the reason some people suggest using ranged rogue who constantly hides before attacking, that gives them advantage and thus sneak attack. It's very easy to get melee sneak attacks, though, when you have 2-3 melee characters in your party.)
So to sum up, a possible party could be:
- Rogue
- Cleric OR Paladin (Insight domain for cleric if you don't use a wizard)
- Barbarian OR Fighter
- Wizard OR Ranger