I have a Northstar camper with a built in cassette toilet. I can dump at home in the toilet. If I had to go to an actual RV dump station, I am not sure where I would need to go. There was a small campground and dump located about 7 miles from my house. That is now closed. There are two other places listed on sanidumps.com but they would take close to 2 hours round trip not counting making arrangements and dumping.
I have had this same sort of issue in many locations. I love my cassette toilet giving me the option to dump in dump stations, outhouses and even in toilets. I rarely use a toilet and when I do I selection a more remote location with a door to the outside and limited other users. It is not messy to dump in a toilet but there is an odor that needs to clear.