Flight in real cloud is quite different to flight under the hood, it's dark, you're getting bounced about, control can be difficult, there's no quick way out by ripping the hood off. You never totally know what's in there. Damned right it's scarey.
My advice? Do it, plan - and I mean plan in excruciating detail, simple IFR trips that'll take you through benign Cu or marginal visibility but no real nasty weather. Do this reasonably often. Slowly build up your confidence, and (really really importantly) develop a realistic understanding of conditions and how you respond to them. Again, slowly, start doing longer real IFR trips, and start bringing yourself down from initially not taking an approach with, say, less than a 1000ft cloudbase, towards your legal minimums.
Also remind yourself of the really useful guidance from the US FAA on personal minima checklists. The ASA IR Oral test guide has good stuff on that.
Instrument flying is not a natural act, it's perfectly reasonable to be nervous of it - probably only a fool is not, especially if not very experienced in it (yet), and especially in real IMC.
G
(UK IR(R) for 7 years, US IR for 2 months, still learning, but living in a country with lots of real IMC so have taken that journey, and experienced that fear and unfamiliarity.)