If you want this to be just visual and not something used for schedules you could use the split face tool.

If it needs to be scheduled you should make a stacked wall for when you have stone and Hardie pannles and a second wall type that is the stone veneer all the way up.

So if I use the split face tool I am essentially pasting the stone finish wherever I want on the elevations but I won't have a partition type to match up to it right? And going the other route will give me more partition types.

Yep that is correct.

Yep, pretty much.

Just FYI, there has been a lot of debate on stacked walls vs. compound walls. I'm new to Revit as well, and started off with stacked walls to do pretty much the same thing you are doing, except mine was stone with brick. They work pretty well, but I've since gone to compound walls and I like them much better. They are easier to work with IMO.

The deciding factor seems to be this:
If the walls thickness is the same for each component (stone on brick, for example. both will be 3 5/8" thick), then use a compound wall.

If the thickness varies (which is what I think your situation will be, unless you are using a manufactured stone), then use a stacked wall.

Anyone else care to agree or disagree? Like I said, I'm a noob also, but this is how I choose which type of wall I'll use.

The paint tool is awesome, mainly since ACAD doesn't have one! lol But I'd rather build the walls correctly than just paint them for visual purposes unless it just can't be built. An example is a split face concrete block wall that you can see both sides of. The material will show both sides split face, when in reality one side is smooth. I paint the smooth side those walls if they are visible.

I have never used stacked walls, or the few times that I did I didn't like them. Could be a lack of understanding on my behalf. I have always created separate walls and aligned/locked them to a grid line, the wall location as core face: exterior. That way the location of the wall will not move with any exterior finish size differences.

To make a wall that has multiple areas of differing materialities one could use the Curtain wall method.
1) Make all the wall types needed
2) Create a wall with the "Curtain Wall 1" and break it up however necessary.
3) replace the curtain "panels" with the necessary wall types from step 1

Thanks everyone for the input. It gives me alot of options to explore!

Good tip JBZ. I keep forgetting that you can replace curtain wall panels with walls. That would probably be the best way if you have a complex wall with a random pattern of materials.

For some reason I don't think that using the curtain wall panel method will clean up very well at corners and will produce other issues.