Is a tight top mattress less comfortable than a pillow-top or Euro-top?

Not necessarily. Tight top mattresses can be very comfortable if their firmness and support profile match your needs. While they usually feel a bit firmer at the surface than pillow-top or Euro-top models, many people appreciate the more stable, supportive feel of a well-built tight top.