Clannad, well-written protagonist, who is not dense and has actual issues of his own
Hoshi Ori Yume Mirai, nothing too special but the protagonist has his own dream
Fureraba, I remember this one being a dumbass but I actually found it absolutely hilarious, it was too much so I kind of thought it was to mock actual self-insert protagonists but I may be reading too much into it