When I worked in an independent shop back in the early 00's when we heard a car pull into the lot with a loud rod knock you assumed it was a ford 3.8. I would say of all the engines I replaced back then the ford 3.8 outnumbered everything else combined by a 4-1 margin. The head gaskets failed at 2-1 margin over everything else combined. These were stock daily drivers, so no, I wouldn't recommend over revving them. I wouldn't recommend under revving them. I wouldn't recommend driving them any further than you are willing to walk home.
A 4th gen f-body with a v6 would be a much better choice for roughly the same money.