If you like autopsies and examining gross pathology, forensics is for you. You may be able to find a job doing hospital cases, but you'd probably have to do something else too. A job doing only hospital cases would be rare. By contrast, you can't swing a dead cat without hitting a forensics job, especially if you're not overly picky about where you want to live.
Forensics is also for you if you have a broad range of interests, not just medicine and science, but, pretty much, almost anything else. If you like to learn about all kinds of things and incorporate that into your daily work, you can't do better than forensics.
The other part is stories; the culmination of an autopsy is the Opinion (or the Clinicopathologic Correlation, in hospital case), which is basically a story about what happed to the decedent. The story incorporates all the stuff you've discovered, through your work, your interpretations of it, and your best guesses. And, even though I know it sounds trite, but when it comes to forensics, the truth, or at least the glimpses of it you catch through your cases, really is stranger and much more fascinating and much more moving than fiction.
Don't count it out just because you're not enamored with microscopy. My guess is you probably haven't had any inspirational exposure. The topic can be very dry and detached. Say, when you do histo labs, you're just looking at slides; you have little if any context with the gross. When you do surgical pathology and autopsies, you MAKE the slides. You evaluate the gross specimen, interpret it, decide which sections to take, take them, look at them, then relate what you see directly back to the gross, which, ultimately, relates back to a real patient. Then you communicate your interpretation to a clinician, or in the case of forensics, a DA or law enforcement person, defense council, family member, etc, who will use your interpretation to make a decision about how to treat a patient, whether to prosecute or exonerate an accused, or to gain an understanding and perhaps begin the process of coming to terms with what happened to a loved one. It's a different ball game. It's your work, start to finish. It makes a difference. I think if you get a taste of that, you'll have a different opinion about looking at slides.
That said, slides are relatively minor, yet sometimes essential, part of forensics. So if you can make it through an AP residency (where, admittedly, slides are a major component), and you do forensics, your slide duties will be cake and your autopsies bread and butter.