For SBs I use regular hotels.
This gives free reign for spending the night, leaving and returning, using the space to hold luggage while out, ...etc. Just like being a tourist. Many can also be booked with amenities like onsens, lounges, restaurants, bars, parking, nicer beds, better furniture .. etc.
I haven't done airbnb or residences since I generally find hotels with easy access to train stations or whatever events we go to.
if just for sex, then the 2-3 hour LHs are perfect.