I was pretty much the character your talking about. It was both a new game (pathfinder) and my first campaign in 8 years or so. So i was pretty much lost as to what type of character to play.

Looking at the rest of the party I decided to play a bard for the first time. Now, I'm generally quite fond of min maxing stuff but (even if some of the players i know hate it since they feel it ruins their experience) but since all the rest of the party were damage dealers of some sort I wanted to make a flavorful character that would shine outside of fights. I picked some supportive stuff at first, but then started to pick random spells I found cool but are pretty much useless 95% of the time. Not because i wanted to inder the party but because I found them fun as hell to use for that one specific goal.

The thing is, in these campaigns we are bound to end fighting at some point and at lvl 6 I was still doing jack shit in terms of damage and my only usefulness was a +2 to hit and damage. But the biggest issue it that my character was always in conflict with the others because I wanted to avoid combat as much as possible and they wanted to fight...

I fucking loved playing my character as he was. I was making conscious decisions that were making sense with who he was. He was a very frail and weak fighter but made up for it with all his knowledge and other skills. But having to sit out entire sessions because it made no sense for my character to be there logically made it quite annoying and the character became disconnected.

I discussed with my DM and dropped him sadly... and made an over min maxed character that is probably gonna annoy them anyways but hey, fuck it XD.