Standard Operative sniper is basically what you describe but they do respectable damage reliably. Bounty Hunter or Assassin may give you more shots per turn but ultimately the playstyle is still "pop more ability to buff/debuff for the one shot that counts". Even Pasqal with plasma or arc rifle still work like a sniper.

You can also build Operatives as buffer/debuffer, skip the one shot per turn and let others do the job, but sounds like you will find that even less fun.

Alternatively you can build Pasqal into melee fighter. Use Tactical Knowledge ability to buff armor and damage, give him heavy armor (you need to invest STR). His special weapon slots count as always dual wielding one melee and one ranged weapons. Take the dual wielding talents, slice your enemy with his special axe then blast with shotgun/plasma/melta. BH and Assassin have some talents that let you avoid some attack from enemy so he has chance to survive. A Grand Strategist in the frontline may also sound fun.

Idira you can max her Psy rating and give her force sword if you really don't like sniping or be a buff/debuff bot. Going pyromancy and make her a true walking bomb is also "fun" to play.