Foot, you didn't fill out your profile, so I don't know where you operate the boat, what kind of boat it is, or what kind of sanitation system you have on it. So I'll just offer these general comments.
The advantage of having a raw water flushing toilet is that the water is always there, and it doesn't cost anything. It won't empty your tanks or take away your ability to shower when desired. The downside is that it often doesn't smell very good, it tends to stain the toilet bowl, and you can get mineral buildup inside the toilet, hoses and fittings from dissolved mineral deposits in the water that tend to settle out during periods on non-use and adhere to the inside of any and all things that are exposed to that water. These deposits are concrete-like and are difficult to remove. They'll build up inside hoses and eventually close them up so that nothing will flow through. They also accumulate inside the toilet, hampering its ability to work properly.
Fresh water flushing toilets operate off of the pressure water system on the boat. If the boat operates in a lake or river, and the toilet flushes with outside water, it is still a raw water flushing toilet. Fresh water toilets use pressurized fresh water only - there's a fair amount of confusion about this. People call me all the time, wanting to discuss their fresh water toilet, when the toilet is actually a raw water toilet - it can get confusing at times! Note that manual toilets are always raw water flushing, and cannot be safely converted to flush with pressurized fresh water. Fresh water toilets operate off of the pressure system on the boat (same water you use for drinking, showering and dishwashing) don't cause any smell, run quieter because the toilet doesn't have a raw water pump, and use less electricity to operate.
The ability to dump a holding tank overboard is OK, provided you are 3 miles or more out in the ocean. If you will never be that far out with the boat, you can't legally dump the tank overboard. So it basically depends on how and where you use the boat. If you hug the coastline, or are in a lake or river, there's no reason to have overboard tank pumping ability, because you can't legally do it anyway. But if you spend time out in the ocean, more than 3 miles offshore, then it'd be a good idea to have that capability. A macerator pump is required if you want to empty the tank when at sea - it won't drain by gravity, it must be pumped out.