I think 240 should be the general max, down to 100.
I like the general idea of 30-yd splits....130-160-190-220.
My home course has 190 (#3), 235 (#7), 130 (#8) and 140 (#13). Not a bad variety, but we miss a par 3 that challenges the 6-7-8 irons, and we skip the long irons and go right to the hybrids/fw metals.
President's, a little muni in Quincy, MA has 6 par 3s with a good variety due to terrain. #2 is about 105, #4 is very downhill 175, #7 is downhill 135, #10 is downhill 150, #13 is straight uphill 190, #18 is 130 slight uphill. You end up with something like SW, 7i, PW, 9i, 4i, and PW. Almost all different clubs.
I think for max length, the upper reaches like 250 and 260 are a bit much for "enjoyability" as there are few players who can reach that distance with some semblance of control (even low 'cappers). I can remember two C&C holes at Talking Stick and Bandon Trails that were in this distance ballpark, but they had ample surrounds and large greens to assist, and they both were good holes. I'm not a fan of hitting Driver on a par 3, but if that is how an architect completes the player's "total game challenge" then so be it.
I am a big fan of the short par 3 surrounded by trouble. Everyone can reach, but a 3 isn't a cinch. I like the idea of a small green where if you hit it, you are rewarded with a shortish birdie putt. Too many times you see this type of hole with a big green (to spread around ball marks?) and it doesn't look congruent to the tee shot.
I play this quirky little course way up north in Maine that has a tiny par 3 of about 110 surrounded by wetlands and overhanging trees. The green has two quadrants and is shaped like an upside-down L. The hole is borderline goofy, but I love the tight target that rewards you with a short putt if you can hit it.