The DIMMs are good looking in their own right, without the plasma tubes. The Green Tesla would suit any Nvidia setup and would be at home in any watercooled setup that uses green coolant. There are red and white/blue versions too, so neutral and AMD fans can pick up a set to suit their systems too.
The plasma tubes up close; The Avexir Raiden Green Tesla memory is tall, so you are going to have some CPU cooler clearance issues if you are using a large cooler.
Though with that said, if you are thinking of buying this memory, you probably are thinking about the plasma tubes and not CPU cooler compatibility at this point.