The only melee I've enjoyed so far is mage/rogue jack of all trades.
You need minimum 8 int, 8 dex to make it work, so you'll suffer a bit when it comes to speed.
The main issue with hybrids though, is CD getting reduced by int/dex/str plus those all improve abilities in other dramatic ways. You're strongly encouraged to stack one stat over another.
There's also the trouble of getting the right talents, it's hard to spread that thin. Backstab is mandatory of course, and you may want to get both know-it-all and bigger and better to make up for needing 8 in both dex and int. Bully is also very strong with backstab and your access to midnight oil. It's rough trying to prioritize.
The main pro of this build is versatility though. With 8 int you still get a ton of spells that don't need more than that, and you can buff yourself up to be a more powerful melee presence than a pure rogue would IMO, for a duration at least.
You've got two hastes, two invisibilities, access to charm and mute, tactical retreat, debuff removals, etc. etc.
I'm not sure it beats a pure mage still, but it beats a pure rogue for me.
TL:DR Embrace the magic for your melee builds.