Officer Frank has two uses: as a deterrent against meat damage and as a way of creating HQ accesses without actually needing to get into HQ.
As a deterrent against meat damage it frankly (pardon the pun) is not that great. The thing with meat damage is that it tends to come into large packages and with the intent to kill. From the corp side meat damage is much harder to land than net damage due to most cards that deal it requiring tags to function. This leads to corps either not bothering with meat damage or building a deck around it. From the perspective of Officer Frank that means he's either useless (no meat to trigger off) or useless (trashing cards doesn't help when you're dead). Sure, there are cards that deal small amounts of meat damage, but they're not very commonly played.
The runner can create their own painful bruising luck though. There are a few cards that can deal meat damage at the whim of the runner:
- Net-Ready Eyes and Titanium Ribs deal 2 meat when installed.
- Tri-maf Contact deals 3 meat when trashed (and is a connection so a potential MCA Informant).
- Mad Dash deals 1 meat damage on a run that didn't steal agendas.
Of these Mad Dash is the most interesting. Officer Frank acts as a consolation price in case you didn't find an agenda, increasing your chances of finding one in archives. And if you happen to not trigger the good officer you're not going to be too sorry with all the agenda points you've gained. Plus the officer will still around for another go.
Overall I think the power level of Officer Frank isn't terribly high, but the combo with Mad Dash is certainly good enough for him to see some play in decks that include Mad Dash.