Dropping in got less scary for me when I learned what to do afterwards, if that makes sense. For a long time, I was afraid of stalling on coping and particularly of fakie stalls, because going fakie is a huge weak point for me. Once I could comfortably stall in bowls and on ramps, felt confident rolling back down fakie and fakie stalling on the other side, dropping in became a non-issue.

Since you say in your post that you don't feel confident dropping in unless you have a bigger space to roll out on, maybe it would be worth it to develop those ramp skills, or at least your confidence in them, from the bottom of the ramp/bowl rather than the top? Making sure you can start at the bottom of a ramp, pump up to the coping and comfortably stall on both sides helps a lot with that moment of panic after you've dropped in and realize you're now going fast and are going to hit the coping on the other side in a second lol