does calling $sth->finish, affect the "caching" of the prepared statement?

No. But if you use selectrow_, there is no need to call finish().