Photophysical and Biological Investigations of Rhenium-Based Anticancer Agents