Unless you are buying for workstation and need the extra power now... Then no! In fact even for work stuff the 2xRX480 would be a better bet. Just one rx480 beats the current Titan in resolve!
Basically unless you intend to make money out of it even then you're probably smoking something if you buy for games!
How does the 480 beat a titan at something?