>>4000Do you prefer manga only or anything? Assuming only manga, I think these might work:
-FAKE: This one's a little dated, but I still adore it even if it might not be for everyone. It's funny and silly for the most part, but during the later parts of the story, it delves into exactly what you're looking for in regard to the uke and themes. I really think this might capture the vibe you're wanting, assuming you can get past the Dorito chins.
-There Are Things I Can't Tell You: This might be a little angsty for your taste, but it does have the psychological aspects and the denial.
It has a happy ending, so don't worry on that front!-Ero Yume Aquarium: I thought this one was cute, and it fits some of your criteria. It's fairly lighthearted and cheerful. It's not terribly psychological, but there are a lot of sea creature facts kek.
-Qualia Under the Snow: I didn't love this, but a lot of people really do. It kind of fits the themes you like with its characters, and it's somewhat psychological.
-Happy Shitty Life: Probably the least fitting recommendation, I'm just going to throw it out there because the characters are pretty tsundere, it's funny, and at least one of them was very tenuously straight at the story's outset.
If you like VNs, I have some more suggestions you might also enjoy.