As title says, I am looking for manga, anime, visual novels, light novels, and full length novels with a realistic(this cannot be stressed enough) depiction of Yakuza. It does not have to be centered around Yakuza, but when they appear it should be legit. Untranslated Japanese novels welcome.

Example:
Kurosagi (make occasional appearances)
Kara no Kyoukai (Novel) (Although an urban fantasy, when Yakuza appear they're realistic)

Reference: https://www.youtube.com/watch?v=AOhuUxtxrmg

This type of request will never end, Smart gangster/ yakuza:
https://www.mangaupdates.com/showtopic.php?tid=52614&page=1&hl=yakuza#post678880

I also read EU/US comics and am a librarian.
Manga-Masters, My ANN-Lists + Imdb