I can tell you, as a player who played a trickster domain cleric from level 1 to 10 in the actual 5e experience... Hitting things with a melee weapon happened maybe once in an entire encounter. Most of the time I was casting my very fun trickster domain spells rather than actually hitting things in melee.
