All the attempts to turn Picard into an action hero/sex icon were lame because they don't play to the character's strengths. The man in an inspiriting orator and philosophical intellectual. Not an action hero. Even "Die Hard in Space" was more like Home Alone than a badass taking down his enemies.

His other romance was well done. Not the one with Vash or Beverly. The one with one of his subordinates.