Visible cloudiness is a result of suspended particles of about 1 micrometer (micron) or larger in size. Technically, just about any juice could in theory be filtered to remove those particles. But there are a couple things going on here.
First, any filtering, clarification, etc. does cause some modification of flavor. Flavor compounds can be much smaller than 1 micron, but how they're perceived can be modified by larger particles that contribute to mouthfeel and by their relative concentrations. If you're measuring against the raw food, any change subtly modifies how it tastes. A raw tomato tastes slightly different from tomato juice, which in turn tastes different than tomato water. This can have an especially strong impact on subtle flavors like vegetable juices.
Second, 1 micron is pretty small. The average pore size for your standard drip coffee filter is about 10-15 microns, meaning you have to go a full order of magnitude smaller in order to remove visible cloudiness. Besides physical filtration, there are other ways to do this like gelatin clarification, but those may also remove things like suspended oils or specific flavor compounds. That might be okay if you mostly care about sweetness and you can add artificial flavors back later (as with mass-produced juice blends) but could be a problem if you're going for a very "natural" flavor. In general, more filtering means more processing and more associated flavor change.
Third, you're right that there is a marketing aspect here. Consumers have grown used to certain types of juice being clear (like apple juice) and others being totally opaque (like orange juice). A certain subset might also actually prefer clouded juices, seeing them as less processed (which they generally are) and therefore more "healthy", regardless of whether that's actually true.
In short, you could filter just about any liquid clear through some means or another, but it will taste different, and will likely affect how much people will pay you for the result.