Funny I should see a post pop up here about this camera as I personally own a Sony DXC-1200P which I won for $5 last year on Ebay and have just got it working yesterday, well not 100% working as the colour is weak to almost non existent but good enough for a decent B&W picture. I have put photos of it on my site
http://1970scountdown.atspace.com/dxc1200.html (mistakenly labeled as DXC-1200CE) and have uploaded a test video yesterday pointing it at a colour bar pattern on my monitor which as seen there's very faint colour
http://www.youtube.com/watch?v=3xKRPb2wLiA .
To answer your question, I believe the typical user environment for these cameras would be same of that with the B&W Sony AVC-3200s which would be high schools (if they were wealthy), colleges, universities, industries, lower budget video production companies, advertising agencies, and possibly some lower budget TV stations pay have possibly used these as I know TV stations have used vidicon cameras for some productions. Basically this colour camera is semi-professional grade and is lower on the rung from the 3 plumbicon tube colour cameras typically used by TV networks at the time like the RCA TK-45.
Anyways great to see yours is working, could you share some video feeds from it with us as I would like to see pictures from this kind of camera in full glorious colour.