Stick behind a 4.7 makes it slightly more fun but yeah, you're still saddled with like 235 hp. Factory upgrade parts are getting harder to find and the 08-12 engine cannot be easily retrofitted to the older platform, though the parts all bolt on and you can custom tune the 4.7's ECM. Alot harder to modify these since there was no factory support and very little aftermarket support (especially since Nick from AIR RAM passed recently). There is a company that still makes blower kits for them:
2000-2007 Dodge RAM 1500 4.7 Liter V8 Supercharger | Boosted Technologies, LLC
A 3G 5.7 stick in a 1500 would've been lotsa fun but they weren't having it for some reason; that combo was only available in 2500/3500 HD trucks. The auto in the early 3G 1500 combo is the weak link in that drivetrain. It's why I ultimately ended up in a 4G.
It would've been a much cheaper alternative but still wouldn't have had near the performance, especially considering the 10 is a whole package of upgrades.
I watched a video YEARS ago, had a bunch of street races in it. One of them was an 04 or 05 quad cab 1500 5.7 with an STS turbo vs a lightly modified SRT-10 RC vs a 2G Lightning. From a 60 roll on a highway the 10 walked everybody, followed closely by the Ram; the Ford blew up (video showed a rod punched out the side of the block lol). Have to see if I can find that video.