I'm aware some of these games aren't necessarily campaign but I listed because I have an abundance of hours on them.

Rating:

• ★☆☆☆☆ = poor
• ★★☆☆☆ = below average
• ★★★☆☆ = average
• ★★★★☆ = above average
• ★★★★★ = excellent

3DS:

• Animal Crossing: New Leaf || ★★★★★
• Animal Crossing: Happy Home Designer || ★★★☆☆
• Phoenix Wright: Ace Attorney || ★★★★★
• Pokemon Sun || ★★★★★
• Phoenix Wright: Ace Attorney - Justice For All || ★★★★★
• Phoenix Wright: Ace Attorney - Trials and Tribulations || ★★★★★
• Apollo Justice: Ace Attorney || ★★★★★
• Phoenix Wright: Ace Attorney - Dual Destinies || ★★★★★
• Monster Hunter Stories || ★★★★★

PS4:

• Until Dawn || ★★★★★
• Kingdom Hearts || ★★★★★
• Kingdom Hearts: Chain of Memories || ★★☆☆☆
• Kingdom Hearts: 358/2 Days || ★★★★★
• Kingdom Hearts 2 || ★★★★★

PC games/visual novels with an ending (no particular order):

• Portal || ★★★★★
  • Portal 2 || ★★★★★
• Diablo 3 || ★★★★☆
  • Reaper of Souls expansion || ★★★★★
• F.E.A.R. 3 || ★★★☆☆
• Borderlands || ★★★☆☆
  • Borderlands 2 || ★★★★★
  • Borderlands: The Pre-Sequel || ★★★★☆
• Saints Row: The Third || ★★★☆☆
• The Walking Dead || ★★★★★
  • The Walking Dead: Season 2 || ★★★★☆
• Among the Sleep || ★★★☆☆
• Trine || ★★★★★
  • Trine 2 || ★★★★★
  • Trine 3 || ★★★☆☆
• HuniePop || ★★★★☆
• Dead Island || ★★★☆☆
• NekoPara: Volume 1 || ★★☆☆☆
  • NekoPara Volume 0 || ★★☆☆☆
• Gauntlet || ★★★☆☆
• Life is Strange || ★★★★★
• Emily is Away || ★★☆☆☆
• Carpe Diem || ★★☆☆☆
• Stardew Valley || ★★★★★
• Dream Daddy || ★★★★☆

PC multiplayer/non-campaign games(no particular order):

• Killing Floor || ★★★★☆
  • Killing Floor 2 || ★★★★★
• TERA || ★★★★☆
• Evolve || ★★★☆☆
• Counter-Strike 1.6 || ★★★★☆
• Payday 2 || ★★★★☆
• Heroes of the Storm || ★★★★☆
• Don't Starve Together || ★★★★★
• Dungeon Defenders II || ★★★★☆
• Left 4 Dead 2 || ★★★★☆
• Terraria || ★★★★☆
• Overwatch || ★★★★★