In many cases, there is a set of coaxial cables (or, on cheap TVs, just a ribbon cable) running from the main tuner/deflection board up to the neckboard that'll have RGB video on it since the NTSC demod is often done in with the tuner stuff. Sometimes, this video is YPbPr ("component"), though, and the colorspace is changed on the neckboard. Depends on the TV. Signal levels are not always standard, of course, but sometimes they are.
If you can determine the nature of this interface, yes, you can chuck RGB video onto it. You still need to feed sync to the deflection generation circuitry in a meaningful way.
If you have sync-on-green, you can just hook that green channel up to the composite video input and then splice the three video channels right up into the neckboard in a manner that is suitable (may need an amp, for example), and it should work (OSD may be weird).
If you have TTL level sync, you'll have to either create SoG or figure out if something simpler will work as an input to the deflection generation (may even be able to find a TTL input somewhere). May need a sync separator if you just have composite sync and of course polarity inversion may also be required.
This is not going to be the type of thing that's guaranteed to work on every television, but it is often possible. The technique will also only work on analog televisions. Anything with a digital scaler will probably want to buffer the video digitally, and that will get all the timing out of whack.
Many newer TVs in the USA have YPbPr component inputs. It's not too hard to convert RGB to YPbPR; it's just a colorspace change. 4 high-speed op-amps and a handfull of passives is sufficient plus some extra stuff to handle sync insertion on luma, or it can be done digitally. This has the advantage that you don't have to mod the TV. Boxes can be bought that do this for about $75. S-Video is also an option. It looks surprisingly good on many TVs when done right. The crappy S-Video outputs on PC video cards don't do the format justice.