Short answer: none of the three on its own. The aspect has no built-in verdict. It has a volume, and the volume decides how much attention it deserves. Read that and you can stop asking whether it is good or bad and start asking what it is asking you to do.
Is it good? In a natal chart, Fortuna opposite Fortuna often produces the most capable people in the room, because the split forces two skills instead of one. The person who can budget and also talk openly about shared money did not arrive there by accident. The aspect built the muscle. In that sense, tight oppositions are productive. They are also demanding, and demanding and good are not the same word.
Is it bad? The friction is real. One end of the axis keeps delivering and the other keeps stalling, and living that for years is tiring. But the aspect does not remove benefit from your life. It relocates it and asks you to walk across the line to collect. Calling that bad is like calling a bridge bad because it is not a door.
So what is it? Loud. That is the honest description. Opposition is one of the most powerful aspects, second only to conjunction, and when the separation is tight, within about 2 degrees of exact 180, the theme performs. Expect it to name itself through recurring arguments, recurring budgets, recurring patterns about who gets to relax. Once you can hear the theme, most of its power stops being mysterious and becomes a choice.
Is a tight orb worse than a loose one? Louder, not worse. A 2-degree hit presses its point and rewards specific decisions. A 6- or 8-degree version runs as background texture and mostly just needs naming. The aspect does not change across the range. Your attention does.
What should I actually do? One small crossing. If the aspect keeps you pushing on the earning side, receive something unearned today. If it keeps you giving, let one person hand you something back. If it keeps you sprinting in the visible half of life, keep one hour for the half nobody sees. That is the whole practice.
Want to see which houses your own axis lands in? Calculate your birth chart — the placement only makes sense inside the whole picture, and the whole picture is easier to read than any single point. If partnership is the live theme, the Juno Opposite Fortuna reading shows the same axis working through commitment. If the split is showing up between you and someone else, the synastry chart calculator maps both points together. If timing is the question, the transit chart calculator checks the current sky against your chart; the Astrology Calendar shows the collective events, not your personal peak days.
One general note: the geometry here is arithmetic. An opposition is exactly 180 degrees apart, measured on a 360-degree circle, and that part is astronomy, not opinion. The meaning layered on top is astrology, which is interpretation. Read it with your own week in front of you and let the recurring pattern, not the label, tell you what is true.