I think most of the members of this site find short par 3s with tiny greens interesting, and I think tour pros would concur. I think the reason that designers shy away from such holes is the fact that the wear and tear on these holes is concentrated, thus the turf conditions on these greens are likely to be the worst on the course. If you concentrate foot traffic, plugs from hole location changes, ballmarks, etc. over a small surface the turf is likely to suffer. Some ways I've seen designers remedy this is with larger greens with distinct tiers, however this does not have the same visual appeal and challenge as a short iron shot to a tiny green.
I'd like to see a double green short par 3 bisected by a stream or bunker, something like that hole at Pine Valley with the two tandem greens (although that is a par 4 no?). If the overall square footage is similar to a mid size green, you could keep the turf in better condition.