So I went through all 91 PS4 games that I currently own.
Games with no paid for DLC/Microtransactions: 61 Titles
Aaru's Awakening
Apotheon
Assassin's Creed Chronicles: China
Axiom Verge
Bloodborne
Bound by Flame
Contrast
CounterSpy
Dark Souls II: Scholar of the First Sin
Daylight
Dead Nation
Diablo III: Ultimate Evil Edition
DmC: Definitive Edition
Dust: An Elysian Tail
Fez
Final Fantasy Type-0 HD
Game of Thrones (Telltale)
Guacamelee! Super Turbo Championship Edition
Hand of Fate
Hotline Miami
inFAMOUS: Second Son (Has a couple pre-order only cosmetics)
inFAMOUS: First Light (Stand Alone Expansion)
Injustice: Gods Among Us Ultimate Edition
Knack
Life is Strange
Mercenary Kings
Metal Gear Solid V: Ground Zeroes
Metro Redux
Natural Doctrine (1 *Free* Minor Content DLC)
Never Alone
OlliOlli 2: Welcome to Olliwood
Pix the Cat
PixelJunk Shooter Ultimate
Resident Evil HD
Road Not Taken
Rogue Legacy
Shadow Warrior
Shovel Knight
Sleeping Dogs: Definitive Edition
Spelunky
Sportsfriends
SteamWorld Dig
Stick it to the Man
Strider
Strike Suit Zero: Director's Cut
Tales from the Borderlands
The Binding of Isaac: Rebirth
The Legend of Korra
The Order: 1886 (has a couple pre-order only cosmetics)
The Swapper
The Unfinished Swan
The Walking Dead: Season 1
The Walking Dead: Season 2
The Wolf Among Us
Titan Attacks!
Tower of Guns
TowerFall Ascension
Transistor
Trine Enchanted Edition
Trine 2 Complete Story
Valiant Hearts: The Great War
Wolfenstein: The New Order (Stand Alone Expansion Coming)
Games with DLC/Microtransactions: 4 Titles
Assassin's Creed: Unity - Currency Microtransactions, "Time Saver" Unlocks, Minor Weapon DLC, Free Content Expansion DLC
Dragon Age: Inquisition - Multiplayer Currency Microtransactions, "Deluxe Edition" Cosmetic/Starter Weapon DLC, Content Expansion DLC (Out on XB1, coming in May on other platforms)
Grand Theft Auto V - Multiplayer Currency Microtransactions
Plants Vs. Zombies Garden Warfare - Multiplayer Currency Microtransactions
Games with just DLC: 26
Assassin's Creed: Black Flag - "Time Saver" Unlocks, Minor Content DLC, Multiplayer Character/Costume DLC, Cosmetic DLC, Content Expansion DLC, Season Pass
Child of Light - Cosmetic DLC, Minor Item Packs
Destiny - Content Expansion DLC
Doki-Doki Universe - Content Expansion DLC
Don't Starve - Content Expansion DLC
Dynasty Warriors 8: Xtreme Legends Complete Edition - By far the most DLC packs that aren't hats, I think more than every other game here combined sans TLOU:R. Costumes, Music, Stages, Base Themes, Weapons, etc. It's ridiculous in a bad way. "Complete Edition" my Irish/Welsh ass.
Dying Light - Season Pass: Cosmetic DLC, Minor Content DLC, Minor Weapon DLC, Free Multiplayer Mode DLC
Escape Plan - Content Expansion DLC
Far Cry 4 - Season Pass: Minor Content DLC, Content Expansion DLC, Multiplayer Modes
Final Fantasy XIV: A Realm Reborn - Typical MMO Service Options & Minor Cosmetics
Killzone: Shadowfall - Cosmetic DLC, Multiplayer Modes
Lego: Marvel Super Heroes - Character Packs
Lords of the Fallen - Minor Weapon/Item DLC/Pre-Order bonuses, Content Expansion DLC
Middle-earth: Shadow of Mordor - Season Pass: Minor Item DLC, Cosmetic DLC, Mode DLC, Content Expansion DLC
Monopoly Plus - Custom Board DLC
Oddworld: New 'n' Tasty - Minor Content DLC
Outlast - Content Expansion DLC
Resident Evil: Revelations 2 - Minor Weapon & Item Storage DLC for Raid Mode, Extra Raid Character + Extra Costumes are Free in Retail Version ($40), must purchase for Digital Version ($25)
Resogun - Cosmetic DLC, Content Expansion DLC
Secret Ponchos - Cosmetic DLC, Character DLC
The Amazing Spider-Man 2 - Cosmetic DLC
The Evil Within - Season Pass: Content Expansion DLC
The Last of Us: Remastered - Cosmetic Multiplayer DLC, Multiplayer Item DLC. By *far* the most number of entries, but mostly Hats.
Thief - Minor Item DLC, Challenge Map DLC, Minor Content Pre-Order DLC
Velocity 2X - Content Expansion DLC
Watch_Dogs - Season Pass: Cosmetic DLC, Minor Weapon/Item DLC, Minor Content DLC, Content Expansion DLC
By far the most purely offensive of the bunch is Dynasty Warriors 8: Xtreme Legends Complete Edition. Especially due to its name - it's not a Complete Edition with 75 DLC entries on PSN. The 4 games I own that actually have Micotransactions in them I find completely harmless or utterly pointless and useless (AC: Unity). I enjoyed the Expansion/Mini-Expansion DLC for AC: Unity, Black Flag, and Watch_Dogs. The Far Cry 4 DLC is pretty bad. I haven't played the Mordor DLC, but everything I've read said it's just disappointing, sadly. I also have the Destiny Expansion Pass, but I have absolutely no desire to actually start playing it again.
I'm looking forward to playing the Lords of Shadow, The Evil Within, and Dragon Age: Inquisition DLC. Really, really excited for the DAI one.
So, basically, I haven't found DLC to effect me in a negative way so far this generation except for being disappointed by the lack of quality in Far Cry 4 and Mordor's DLC and Dynasty Warriors 8: Xtreme Legends "Complete Edition's" atrocious bullshit. The rest of it is fairly harmless and non-intrusive and I don't feel that they've really taken anything away from the games that I like thus far. And hell, the most annoying part of AC: Unity wasn't "DLC" - it was the Companion App & Initiates website chests. Thankfully, they patched that bullshit out of the game months ago.
Maybe if I played Military Shooters (CoD/BF), Music Games, Fighting Games, and Sports Games I'd feel differently, since I don't really have any experience with those, but so far this generation has been really light on DLC and Microtransactions for the rest of the industry.