Couple of things here...
They may ask for your transcripts anywhere you work. I would NOT, and I repeat, NOT want to pick a hospital just based on this criteria alone. If you end up working in the bowels of the worst hospital in town, you will kick yourself for at least not trying to apply someplace else.
That being said, I was asked to show my transcripts at my hospital. I don't think they will fire you based on what they see! It's not important that you got C's or what have you, it's important that you passed the NCLEX. (Congrats BTW
They made a copy of mine, made a comment on them, and then filed them away. BUT-they just needed proof that I graduated, since Pima doesn't give out their diplomas for like 12 weeks after graduation. Also, Az doesn't have GNs, so even though I had my license#, they still wanted to just see proof that I went to school and received my diploma.
Also, I know quite of a few of my classmates who barely, and I mean barely by the skin of their teeth, passed NS who are working at UMC.
That being said: what side of town do you live on, and what kind of nursing do you like to do? I might have a recommendation for you!