Maximal violations and efficiency requirements for Bell tests with photodetection and homodyne measurements