I've heard and read thru the decades that the 4.0 sohc engine is a unique engine to work with for that proper exhaust performance and sound. Kinda like the 4.6 engine. The 4.0 ohv engines sound good with most various flowmasters. The 4.0 sohc sounds good with super 40 super 44, from what I've heard.
Are you only replacing the muffler only or complete system with new pipe? If muffler only with stock pipe will be fairly quiet with a little tone. When you change the pipe size to 2 1/4 to 2 1/2, that where the sounds really come out.
I used to own a 1994 ford ranger 3.0 5spd for 31 years, I only ran flowmaster, never like those straight thru mufflers. I ran a 50 series deltaflow from 1998 to 2001. Used the original 40 from 2001 to 2022. Went the super 44 from 2022 to 2025 when my 94 ranger was totaled. Always had 2 1/2 piping on there, and the original 40 sounded the best, yet i really did like the 44..it had that tone i liked, more mellow yet redefined with that flowmaster sound.
I now have a 1997 ford ranger 3.0 5spd, i had a flowmaster original 40 installed that i found cheap at the junkyard, had it installed with 2 1/2 pipe. After 6 months I will soon have a 50 series deltaflow installed. I never had a chance to use the deltaflow 40 series, it's another muffler that sounds good.
I believe the super will be alright with you. The super 40 case is 5", where as the original 40, deltaflow 40, super 44 are in a 4" case. The bigger case will produce more sound as well.