Specific to Flickr URLs, its the '_d' at the end. Remove it and you can view it normally in the browser. But as danielbln wrote, that 'Content-Disposition' header is what forces a download in general.
Thanks, I had always wondered why some sites behave differently with some file types. A bit annoying, if you just want to glance at something for a while but not keep it around for longer.