There are no RC trains.
ICE, IC, and EC trains are "long-distance" trains. All of these use the Rhine's west bank.
There are two types of regional trains that serve the same riverbank: RB (Regionalbahn, the most stops)
RE (Regional Express, fewer stops)
The long-distance trains generally make the fewest stops. However, from the main (Hbf) Cologne station, the station that is closest to most things in Cologne, you will still need to transfer to Cologne's Messe-Deutz station (across the river from most of Cologne) by regional train or S-Bahn before boarding these trains. See map.
The really short trips (like 1 -1.5 hours) you will find at DB from Köln Hbf to Frankfurt Hbf all bypass the Rhine Valley.
It sounds like you do not wish to make any transfers, but that's not possible unless you are actually starting from Messe-Deutz and using the long-distance trains.
"...would it be traveling too fast to appreciate those views of the castles?"
You can catch glimpses from all the trains - you'll look out across the river to the ones on the opposite river bank. The ones on the same side of the river as your train will not be visible since they are high on the cliffs above your train. All the trains go too fast for real "appreciation."
I suggest that you arrange to get off the train in 1 or 2 places for better viewing. Any of the regional-trains-only tickets will allow you to hop off and hop back on a later train after an hour or so. With these tickets, a change in Koblenz is required. I'd break the journey into a two-part train itinerary as follows from the DB site. Before searching, be sure to click the "only local transport" option to get just the regional train options:
1) Köln Hbf > St Goar: (a change of train at Koblenz Hbf will appear.) Through this part of the river, this west-bank perspective offers the best views.
2) St Goarshausen > Frankfurt Hbf (this train ride uses the EAST bank.)
St. Goar is quite small but stopping there provides one of the nicest views on the river. The walk from station to the riverfront and the ferry is very short. Also, there's a FERRY CROSSING there. Use it to reach St. Goarshausen on the other side and enjoy the views on the way. Then ride the "VIA" train (a regional train) south along the east bank from there to Frankfurt - the views from that side across the river are very good.
Here is the St. Goar > St. Goarshausen ferry schedule. 2-3 crossings per hour. €2 to cross.
The Day Ticket for Germany will allow you to use any regional trains you like... all day long on Sat or Sun, after 9 am on weekdays:
https://int.bahn.de/en/offers/regional/day-ticket-germany