Portal games and Ratchet games come to mind.
A couple of indies like Shantae, Undertale and even Hades at times are rather funny.
Never played Borderlands tho, but I've been thinking about playing the new Tiny Tina game? Seemed fun.
Sometimes theres games that I find accidentaly very funny (or cringy, I guess it depends) for reasons like really bad voice acting or just plain terrible dialogue. Like Star Ocean or Final Fantasy X. Funny but not by design.