Most tourists who end up here do so only for a couple of hours before being rushed on south to Kratie or north to the Laos border. But, like anywhere in Cambodia, you could easily spend a day here relaxing by the river (don't plan on a week here, of course). There are a couple of sights to see here, but not enough to seriously keep yourself occupied.
The only meaningful sight in Stung Treng is watching the sun set and rise over the landscape. Great for lounging in a hammock, bottle of Angkor Beer in hand, lazily chatting with your compadres.