The Singing Detective (2003)
The Singing Detective is a 2003 American musical comedy crime film directed by Keith Gordon and based on the BBC serial of the same name, a work by British writer Dennis Potter. It stars Robert Downey, Jr. and features a supporting cast that includes Katie Holmes, Adrien Brody, Robin Wright Penn, and Mel Gibson, as well as a number of songs from the 1950s.
More at Wikipedia.